Copy a MySQL Table
This is a simple query but in case you keep forgetting how to do it, and hate searching for it every time you need the query, bookmark this post. Here’s the query:
CREATE TABLE new_table SELECT * FROM existing_table
This is a simple query but in case you keep forgetting how to do it, and hate searching for it every time you need the query, bookmark this post. Here’s the query:
CREATE TABLE new_table SELECT * FROM existing_table
Enter the query to search and hit enter.