CREATE TABLE student.student information1(
studentNo INT(4)
COMMENT ‘学号’,
loginPwd VARCHAr(20)
NOT NULL DEFAULT ‘NULL’ ,
StudentName VARCHAr(20)
NOT NULL DEFAULT ‘NULL’ COMMENT ‘学生姓名’,
Sex TINYINT(1)
NOT NULL DEFAULT ‘0’ COMMENT ‘性别取值0或1’,
GradeId INT(11)
NOT NULL DEFAULT ‘1’ COMMENT ‘年级编号’,
Phone VARCHAr(50)
COMMENT ‘联系电话，允许为空，即可选输入’,
Address VARCHAr(255)
COMMENT ‘地址，允许为空，即可选输入’,
Borndate DATETIME
NOT NULL DEFAULT ‘19940528’ COMMENT ‘出生时间’,
Email VARCHAr(50)
COMMENT ‘邮箱账号，允许为空即可选输入’,
identityCard VARCHAr(18)
NOT NULL DEFAULT ‘NULL’ COMMENT ‘身份证号’ );
