多表查询
一,创建student和score表
1,student表
SQL代码如下:
create table student (
-> id INT(10) NOT NULL UNIQUE PRIMARY KEY,
-> name VARCHAR(20) NOT NULL,
-> sex VARCHAR(4),
-> birth YEAR,
-> department VARCHAR(20),
-> address VARCHAR(50)
-> );
2,score表
SQL代码如下:
create table score (
-> id INT(10) NOT NULL UNIQUE PRIMARY KEY AUTO_INCREMENT,
-> stu_id INT(10) NOT NULL,
-> c_name VARCHAR(20),
-> grade INT(10)
-> );