CREATETABLE student (
id tinyint(5) zerofill auto_incrementnotnullcomment'学生学号',
name varchar(20)defaultnullcomment'学生姓名',
age tinyintdefaultnullcomment'学生年龄',
class varchar(20)defaultnullcomment'学生班级',
sex char(5)notnullcomment'学生性别',uniquekey(id))engine=innodbcharset=utf8;;CREATETABLE student (
id tinyint(5)auto_incrementdefaultnullcomment'学生学号',
name varchar(20)defaultnullcomment'学生姓名',
age tinyintdefaultnullcomment'学生年龄',
class varchar(20)defaultnullcomment'学生班级',
sex char(5)notnullcomment'学生性别',uniquekey(id))engine=innodbcharset=utf8;;