基于数据库school创建course和student表

创建表
创建course表
CREATE TABLE course (

cs_id int(11) NOT NULL COMMENT ‘课程编号’,

cs_name varchar(50) NOT NULL COMMENT ‘课程名称’,

cs_credit tinyint(255) unsigned DEFAULT NULL COMMENT ‘课程学分’,

cs_type char(12) DEFAULT NULL COMMENT ‘课程类别’,

cs_depart char(6) DEFAULT NULL COMMENT ‘院系名称’,

PRIMARY KEY (cs_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;
创建student表
CREATE TABLE student (
stu_id bigint(11) unsigned NOT NULL COMMENT ‘学号’,
stu_name char(12) NOT NULL COMMENT ‘姓名’,
stu_sex enum(‘男’,‘女’) DEFAULT NULL COMMENT ‘性别’, stu_age tinyint(255) unsigned DEFAULT NULL COMMENT ‘年龄’, stu_major char(9) DEFAULT NULL COMMENT ‘专业’,
stu_college char(12) DEFAULT NULL COMMENT ‘学院’,
PRIMARY KEY (stu_id)
)