Correcting teacher:查无此人
Correction status:qualified
Teacher's comments:完成的不错,继续加油
创建数据表
![]CREATE TABLE
NewTable(
姓名varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名' ,
学号tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '学号' ,
班级varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 一班 COMMENT '所在班级' ,
语文tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '语文成绩' ,
数学tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '数学成绩' ,
英语tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '英语成绩' ,
历史tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '历史成绩' ,
地理tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '地理成绩' ,
化学tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '化学成绩' ,
总成绩tinyint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '总成绩' ,
名次` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘排名’,
)
`