MySQL – add contents of another table

INSERT INTO table1 (columnA, columnB, columnC, columnD) SELECT columnA, columnB, columnC, columnD FROM table2;

Leave a Reply

Your email address will not be published. Required fields are marked *