create table Student(
Sno char(8) NOT NULL primary key,
Sname varchar(8) NOT NULL,
Sex char(2) NOT NULL default '男',
Birth datetime NOT NULL,
Classno char(3) NOT NULL,
Entrance_date datetime NOT NULL,
Home_addr varchar(40));
额,今天创建表时显示:Invalid default value for 'Sex'
然后查了下字符集 命令:show variables like 'char%';
额,发现数据库的默认字符集时latinl,立马把它改掉了,alter database homework_one character set utf8;
重新创建,终于成功...鸡冻!