添加默認值“保密”報錯
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'?
2016-02-16
在新建數據庫下面添加一條語句：alter database shop_s ?character set utf8;