Sometimes we require to copy an existing MySQL table to another table, usually we get the SQL dump and execute it to create the new table, but we have a shortcut to do that.
For instance if we need to make a copy of go4expert_users to a table named go4expert_users_new we need to execute the following command.
The query copies the data from old to new.Try it!
For instance if we need to make a copy of go4expert_users to a table named go4expert_users_new we need to execute the following command.
Code: SQL
INSERT go4expert_users_new SELECT * FROM go4expert_users;
The query copies the data from old to new.Try it!
