UNIQUE关键字:
ALTER students
创建唯一索引且具有唯一性约束:
ADD UNIQUE INDEX uni_name (name);
不创建唯一索引但是具有唯一性约束:
ADD CONSTRAINT uni_name UNIQUE (name);
添加索引:
ADD INDEX uni_score (score);
Sign in to make a reply
清竹.
UNIQUE关键字:
ALTER students
创建唯一索引且具有唯一性约束:
ADD UNIQUE INDEX uni_name (name);
不创建唯一索引但是具有唯一性约束:
ADD CONSTRAINT uni_name UNIQUE (name);
添加索引:
ALTER students
ADD INDEX uni_score (score);