Using Create/Select to Create a New Table From Another

In a single statement you can copy the structure and data from one table in MySQL and populate the results of a query into the new table.

CREATE TABLE tblDestination SELECT * FROM tblSource;

Leave a Reply

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