#约束
#主键约束
CREATE TABLE t17 ( id INT PRIMARY KEY, NAME VARCHAR ( 10 ), age INT );
#同时设置两个主键
CREATE TABLE t19 (
id INT,
NAME VARCHAR ( 10 ),
age int,
PRIMARY KEY ( id, age ));
#外键 先有主键才可以创建外键 外键是可以是空值的
CREATE TABLE tt11 (
id INT,
NAME VARCHAR ( 10 ),
tid INT,
CONSTRAINT fk_tid FOREIGN key ( tid ) REFERENCES t19 ( id ));
#非空约束
CREATE TABLE tt12 (
id INT,
NAME VARCHAR ( 10 ) not null,
tid INT,
CONSTRAINT fk_tidd FOREIGN key ( tid ) REFERENCES t19 ( id ));