创建数据表
]
CREATE TABLENewTable(姓名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 ‘排名’,
)
`