/*域完整性*/
DROP TABLE t_student;
CREATE TABLE t_student(
s_id INT NOT NULL,
s_name VARCHAR(20) NOT NULL,
s_age INT NOT NULL UNIQUE,
s_phone BIGINT DEFAULT 132,
PRIMARY KEY (s_id)
);
INSERT t_student(s_id,s_name,s_phone)VALUES(3,NULL,123);
INSERT t_student(s_id,s_name,s_age)
VALUES(4,'wang',18);
INSERT t_student(s_id,s_name,s_age,s_phone)
VALUES(5,'wang',18,NULL);
/*外键*/
SELECT * FROM t_student;
CREATE TABLE t_student(
s_id INT NOT NULL,
s_name VARCHAR(20) NOT NULL,
s_age INT NOT NULL UNIQUE,
s_phone BIGINT DEFAULT 132,
s_t_id INT,
PRIMARY KEY (s_id),
CONSTRAINT teaKey FOREIGN KEY (s_t_id) REFERENCES t_tea(t_id)
);
CREATE TABLE t_tea(
t_id INT PRIMARY KEY,
t_name VARCHAR(20),
t_age INT
);
DROP TABLE t_student;
DROP TABLE t_student;
CREATE TABLE t_student(
s_id INT NOT NULL,
s_name VARCHAR(20) NOT NULL,
s_age INT NOT NULL UNIQUE,
s_phone BIGINT DEFAULT 132,
PRIMARY KEY (s_id)
);
INSERT t_student(s_id,s_name,s_phone)VALUES(3,NULL,123);
INSERT t_student(s_id,s_name,s_age)
VALUES(4,'wang',18);
INSERT t_student(s_id,s_name,s_age,s_phone)
VALUES(5,'wang',18,NULL);
/*外键*/
SELECT * FROM t_student;
CREATE TABLE t_student(
s_id INT NOT NULL,
s_name VARCHAR(20) NOT NULL,
s_age INT NOT NULL UNIQUE,
s_phone BIGINT DEFAULT 132,
s_t_id INT,
PRIMARY KEY (s_id),
CONSTRAINT teaKey FOREIGN KEY (s_t_id) REFERENCES t_tea(t_id)
);
CREATE TABLE t_tea(
t_id INT PRIMARY KEY,
t_name VARCHAR(20),
t_age INT
);
DROP TABLE t_student;