1.表结构完全一样
INSERT INTO 目标表 SELECT * FROM 来源表;
2.表结构不一样(这种情况下得指定列名)
INSERT INTO 目标表 (字段1, 字段2, ...) SELECT 字段1, 字段2, ... FROM 来源表;(这里的话字段必须保持一致)
INSERT INTO excelinfo(`name`) (SELECT CONCAT('2016',dept) FROM `20` WHERE grade='2016' GROUP BY dept)
1.表结构完全一样
INSERT INTO 目标表 SELECT * FROM 来源表;
2.表结构不一样(这种情况下得指定列名)
INSERT INTO 目标表 (字段1, 字段2, ...) SELECT 字段1, 字段2, ... FROM 来源表;(这里的话字段必须保持一致)
INSERT INTO excelinfo(`name`) (SELECT CONCAT('2016',dept) FROM `20` WHERE grade='2016' GROUP BY dept)