根据table2的记录插入table1: INSERT INTO table1 (id, column1) SELECT UUID(),column1 FROM table2; 转载于:https://my.oschina.net/u/1377764/blog/410371