mysql 复制数据

1、表存在

insert into table_name(key1,key2) select key3,key4 from table_name_2;

 

2、表不存在

create table test (
    select key1,key2 from table_name
);