sqlite版

create table actor_name as
select first_name, last_name from actor;

mysql版(as可去可不去)

create table actor_name
select first_name, last_name from actor;