创建唯一索引和普通索引
对first_name创建唯一索引uniq_idx_firstname
https://www.nowcoder.com/practice/e1824daa0c49404aa602cf0cb34bdd75
/*创建表时创建索引: create table [表名]( [属性名1] [数据类型1] [约束1], ... [属性名n] [数据类型n] [约束n], [unique | fulltext | spatial] index|key [索引名]( [属性名1] [(长度)] [asc | desc], ... [属性名n] [(长度)] [asc | desc] ) ); 在已创建的表格上创建索引: alter table [表名] add [unique|fulltext|spatial] [index|key] [索引名]( [属性名1] [(长度)] [asc | desc], ... [属性名n] [(长度)] [asc | desc] ); */ alter table actor add unique uniq_idx_firstname(first_name); alter table actor add index idx_lastname(last_name);
还是自测报错,直接提交就通过。