创建student表

stu_id '学号', stu_name '姓名', stu_sex '性别', stu_age '年龄', stu_major '专业', stu_college '学院'

创建course表

cs_id '课程编号', cs_name '课程名称', cs_credit '课程学分', cs_type '课程类别', cs_depart '院系名称'

mysql> desc student; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | stu_id | int(11) | YES | | NULL | | | stu_name | varchar(255) | YES | | NULL | | | stu_sex | varchar(255) | YES | | NULL | | | stu_age | int(11) | YES | | NULL | | | stu_major | varchar(255) | YES | | NULL | | | stu_college | varchar(255) | YES | | NULL | | +-------------+--------------+------+-----+---------+-------+

mysql> desc course; +------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+-------+ | cs_id | int(11) | YES | | NULL | | | cs_name | varchar(255) | YES | | NULL | | | cs_credit | int(11) | YES | | NULL | | | cs_type | varchar(255) | YES | | NULL | | | cs_depart | varchar(255) | YES | | NULL | | +------------+--------------+------+-----+---------+-------+