题解 | #创建一个actor_name表#
创建一个actor_name表
http://www.nowcoder.com/practice/881385f388cf4fe98b2ed9f8897846df
知识点补漏:掌握解法1
解法1
CREATE TABLE IF NOT EXISTS actor_name
SELECT first_name,last_name from actor;
解法2
CREATE table IF NOT EXISTS actor_name(
first_name varchar(45) not null,
last_name varchar(45) not null
);
insert into actor_name
SELECT first_name,last_name
FROM actor;