创建索引题解
对first_name创建唯一索引uniq_idx_firstname
http://www.nowcoder.com/questionTerminal/e1824daa0c49404aa602cf0cb34bdd75
sqlite创建单列索引语法为:
CREATE INDEX index_name ON table_name (column_name);
创建唯一索引语法为:
CREATE UNIQUE INDEX index_name on table_name (column_name);
结合语法格式可得答案如下:
CREATE UNIQUE INDEX uniq_idx_firstname on actor (first_name); CREATE INDEX idx_lastname ON actor (last_name);