INSERT INTO TABLE1 SELECT * FROM TABLE2; TABLE1表中字段比TABLE2多 INSERT INTO TABLE1 SELECT 'extra1','extra2',b,c,d FROM TABLE2;
INSERT INTO TABLE1 SELECT * FROM TABLE2; TABLE1表中字段比TABLE2多 INSERT INTO TABLE1 SELECT 'extra1','extra2',b,c,d FROM TABLE2;
转载于:https://www.cnblogs.com/xiao-fy/p/5070773.html