MySQL – add contents of another table INSERT INTO table1 (columnA, columnB, columnC, columnD) SELECT columnA, columnB, columnC, columnD FROM table2;