insert into 新表名 (字段1,字段2) select 字段1 as 字段1, 字段1 as 字段1 from 旧表名 转载于:https://blog.51cto.com/ourea/1542329