Need to copy a table in MySQL? Real easy to do, just run the following command:
CREATE TABLE new_table SELECT * FROM original_table
Not only does it copy the structure, it inserts each record from the original table.
Need to copy a table in MySQL? Real easy to do, just run the following command:
CREATE TABLE new_table SELECT * FROM original_table
Not only does it copy the structure, it inserts each record from the original table.
0 Comments