
修改表时删除约束
DROP TABLE IF EXISTS stuinfo;CREATE TABLE stuinfoid INT,stuName VARCHAR20,gender CHAR1,seat INT,age INT,majorid INT;# 添加非空约束ALTER TABLE stuinfo MODIFY COLUMN st......
列级约束案例:CREATE TABLE majorid INT PRIMARY key,majorName VARCHAR20;CREATE TABLE stuinfoid INT PRIMARY key,stuName VARCHAR20 NOT NULL,gender CHAR1,seat INT UNIQUE,a......