创建学生表

create table student(

id int,

name varchar(20),

sex char(2),

age int,

dept varchar(30),

primary key(id)

);

创建课程表

create table course(

id int,

name varchar(30),

pid int,

credit it,

primary key(id),

foreign key(pid) references course(id)

);

MySql语法