CREATE TABLE myschema.mytable ( id integer auto_increment NOT NULL, age int NULL, year_of_birth bigint NULL, name text NULL, weight double NULL, is_married bit NULL );