SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE person ( person_id smallint unsigned NOT NULL, fname varchar(20) DEFAULT NULL, lname varchar(20) DEFAULT NULL, eye_color enum('BR','BL','GR') DEFAULT NULL, birth_date date DEFAULT NULL, street varchar(30) DEFAULT NULL, city varchar(20) DEFAULT NULL, state varchar(20) DEFAULT NULL, country varchar(20) DEFAULT NULL, postal_code varchar(20) DEFAULT NULL, PRIMARY KEY (person_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ; ALTER TABLE person MODIFY person_id smallint unsigned NOT NULL AUTO_INCREMENT; describe person;