题解 | 37#对first_name创建唯一索引uniq_idx_firstname#
对first_name创建唯一索引uniq_idx_firstname
http://www.nowcoder.com/practice/e1824daa0c49404aa602cf0cb34bdd75
第一种:
ALTER TABLE actor ADD unique uniq_idx_firstname (first_name); alter table actor add index idx_lastname (last_name)
第二种:
create unique index uniq_idx_firstname on actor (first_name); create index idx_lastname on actor (last_name)
sql题 文章被收录于专栏
牛客网里面的sql题,把答案和思路写下来