MySQL copy table to another

Copy one table to another in MySQL

In some cases, you may need to copy only the data of one table to another one with the same structure. Instead of using a tool like MySQL Workbench, you can do it by running a query.