INSERT INTO 新表(字段1,字段2,.......) SELECT 字段1,字段2,...... FROM 旧表 转载于:https://www.cnblogs.com/Lxiaojiang/p/6203380.html