mysql-enum

CREATE TABLE student(
	id INT(11) PRIMARY key auto_increment,
	name VARCHAR(10) not null,
	sex ENUM('boy','girl','secret') DEFAULT 'secret'
)ENGINE=INNODB

记录一下笔试懵逼细节

 

查看表：desc [table]