添加默认值“保密”报错
CREATE TABLE `shop_user` (
`id` int unsigned AUTO_INCREMENT KEY ,
`username` varchar( 20 ) NOT NULL UNIQUE ,
`password` char( 32 ) NOT NULL ,
`sex` enum( "男", "女", "保密" ) NOT NULL default "保密",
`face` varchar( 50 ) NOT NULL ,
`regTime` int unsigned NOT NULL
);
MySQL 返回:
#1067 - Invalid default value for 'sex'