In the case of existing table with the same structure:
INSERT table2 SELECT * FROM table1 WHERE [conditions]
Alternative syntax for a table with different structure:
INSERT table2 (columnA, columnB) SELECT column1, column2 FROM table1 WHERE [conditions]
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment