1.建表同时导入(对于MySQL,那么AS可以去掉,也可以不去掉):
CREATE TABLE actor_name AS
SELECT first_name,last_name
FROM actor
2.先建表,然后导入:
CREATE TABLE 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;