DROP TABLE IF EXISTS `imooc_user`;
CREATE TABLE `imooc_user`(
`id` int unsigned auto_increment Key,
`username` varchar(20) not null unique,
`password` varchar(32) not null,
`sex` enum("男","女","保密") not null default "保密",
`face` varchar(50) not null,
`regTime` int unsigned not null
);
报错 #1067 - Invalid default value for 'sex'