MySql中把一个表的数据插入到另一个表中

两表字段一致： INSERT INTO 目标表 SELECT * FROM 来源表;

insert into Test1 select * from Test2;

两表字段不一致 INSERT INTO 目标表 (字段1, 字段2, …) SELECT 字段1, 字段2, … FROM 来源表;

insert into Test2(id，other) select id,other from Test1;

INSERT INTO cts_sendsms_record (send_id,send_phone,msg_id,result_code,result_desc,smssend_code,receive_time,sms_msg,send_time) 
SELECT id,send_phone,msg_id,result_code,result_desc,smssend_code,receive_time,sms_msg,send_time FROM cts_send_record ;

复制表结构及数据到新表

CREATE TABLE TABLE_NEW AS SELECT * FROM TABLE_OLD;

只复制表结构到新表

CREATE TABLE TABLE_NEW AS SELECT * FROM TABLE_OLD WHERE 1=0;