不重复,可以为空 给名字添加唯一的 约束 create table stu3( id int primary key, name varchar(50) unique ); insert into stu3(id,name)values(1,‘zaf’); insert into stu3(id,name)values(2,‘zaf’); ERROR 1062 (23000):Duplicate entry ‘zsf’ for key insert into stu3(id,name)values(2,‘za’);
唯一约束(unique)不重复,可以为空给名字添加唯一的 约束create table stu3(id int primary key,name varchar(50) unique);insert into stu3(id,name)values(1,‘zaf’);insert into stu3(id,name)values(2,‘zaf’);ERROR 1062 (23000):Duplicate entry ‘zsf’ for keyinsert into stu3(id,nam