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. Code: INSERT go4expert_users_new SELECT * FROM go4expert_users; The query copies the data from old to new.Try it!
Hey dear! I love this topic and want to know more about MQL. There is something different between mysql and sql