1、新建输据库
//选择输据库
mysql> use student;
Database changed
mysql> create table Student
-> (Sno char(10) primary key, //注意括号在这一行
-> Sname char(20) not null,
-> Ssex char(2),
-> Sage smallint,
-> Sdept char(20));
Query OK, 0 rows affected
//创建成功
2、创建带有表级完整性约束的表
mysql> use student;
Database changed
mysql> create table Course
-> (Cno char(4) primary key,
-> Cname char(20) not null,
-> Cpno char(4), //先行课
-> Ccredit smallint,
-> foreign key(Cpno) references Course(Cno) //表级完整性约束,Cpno是外码
//被参照表是Course,参照表中Cno
-> );
Query OK, 0 rows affected
创建选课表:
mysql> create table SC
-> (Sno char(10),
-> Cno char(4),
-> Grade smallint,
-> primary key(Sno,Cno), //主码(Sno,Cno)
-> foreign key(Sno) references Student(Sno),
-> foreign key(Cno) references Course(Cno)
-> );
Query OK, 0 rows affected
3、添加列
mysql> alter table test
-> add newcol char(4) unique; //add 【colnum】<列名><数据类型><列级完整性约束>
Query OK, 0 rows affected
4.添加外键约束:
还可以做其他修改