insert into 目的表 select * from 表 where 条件 https://www.cnblogs.com/jicheng/p/6924793.html 转载于:https://www.cnblogs.com/lq0418/p/8931864.html