MySQL copy table data to a new table

April 18, 2020

This post brought to you by RocketGeek, ButlerBlog, and the following:

CREATE TABLE backup_table LIKE existing_table;
INSERT backup_table
SELECT * FROM existing_table;