mysqlHow to duplicate table structure and data

CREATE TABLE new LIKE old;
INSERT INTO new SELECT * FROM old;ctrl + cyoutubegithub

`CREATE TABLE new` create new table named `new`	`LIKE old` our `new` table will have the same structure as `old` (our current table)
`INSERT INTO new SELECT * FROM old` will copy all the data from `old` to `new`