知识点补漏:掌握解法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;