MySQL下将一个表的数据插入到另外一个表的实现语句

INSERT INTO 目标表 SELECT * FROM 来源表;

INSERT INTO newArticles SELECT * FROM articles;

INSERT INTO 目标表 (字段1, 字段2, ...) SELECT 字段1, 字段2, ... FROM 来源表;