How to Duplicate a Table in MySQL
Last updated July 24, 2026 · By the SaturnSQL team
CREATE TABLE new LIKE old copies the structure including indexes; INSERT INTO new SELECT * FROM old copies the rows. CREATE TABLE ... AS SELECT is shorter but drops indexes and keys.
Full copy with indexes (recommended)
CREATE TABLE orders_backup LIKE orders;
INSERT INTO orders_backup SELECT * FROM orders;Quick copy, no indexes
CREATE TABLE orders_copy AS SELECT * FROM orders;Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free