Discuss / SQL / *两种方式*
Back

*两种方式*

Topic source

小甜甜郑林200

#1 Created at ... [Delete] [Delete and Lock User]

添加唯一索引：

>ALTER TABLE students
ADD CONSTRAINT uni_name UNIQUE (name);

只添加唯一约束而不添加唯一索引：   

>ALTER TABLE students
ADD UNIQUE INDEX uni_name (name);

  • 1

Reply