SQL231. 对first_name创建唯一索引uniq_idx_firstname
描述
CREATE TABLE actor ( actor_id smallint(5) NOT NULL PRIMARY KEY, first_name varchar(45) NOT NULL, last_name varchar(45) NOT NULL, last_update datetime NOT NULL);
Sqlite 解法, 执行用时: 9ms, 内存消耗: 3304KB, 提交时间: 2021-05-29
Create unique Index uniq_idx_firstname on actor(first_name); Create Index idx_lastname on actor(last_name)
Sqlite 解法, 执行用时: 10ms, 内存消耗: 3248KB, 提交时间: 2021-07-26
create unique index uniq_idx_firstname on actor(first_name); create index idx_lastname on actor(last_name);
Sqlite 解法, 执行用时: 10ms, 内存消耗: 3252KB, 提交时间: 2021-07-24
CREATE UNIQUE INDEX uniq_idx_firstname on actor(first_name); CREATE INDEX idx_lastname ON actor(last_name);
Sqlite 解法, 执行用时: 10ms, 内存消耗: 3284KB, 提交时间: 2020-10-29
CREATE UNIQUE INDEX uniq_idx_firstname on actor(first_name); CREATE INDEX idx_lastname ON actor(last_name);
Sqlite 解法, 执行用时: 10ms, 内存消耗: 3292KB, 提交时间: 2020-07-12
create unique index uniq_idx_firstname on actor(first_name); create index idx_lastname on actor(last_name);