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'
2014-08-30
可以成功啊 你看看你在寫中文之前是否臨時轉換客戶端編碼了
^_^...