mysql——基本约束
主键约束:
col_name col_name_type PRIMARY KEY; //适用于单个字段的主键;
CONSTRAINT constraint_name PRIMARY KEY(col_name);
CONSTRAINT constraint_name PRIMARY=KEY(col_name1,col_name2,……); //适用于复合主键(多个字段组成的主键);
唯一约束:
col_name col_name_type UNIQUE KEY;
默认约束:
col_name col_name_type DEFAULT;
非空约束:
col_name col_name_type NOT NULL;
外键约束:
CONSTRAINT constraint_name FOREIGN KEY(col_name) REFERENCES tb_name(col_name) ;