Skip to content

Instantly share code, notes, and snippets.

@DominicWatts

DominicWatts/mysql-copy-table-syntax

Created June 30, 2020 19:34
Show Gist options
  • Save DominicWatts/7163aaab1fbfb0a926fc7445cf9c8bd4 to your computer and use it in GitHub Desktop.
Save DominicWatts/7163aaab1fbfb0a926fc7445cf9c8bd4 to your computer and use it in GitHub Desktop.
Download ZIP
mysql copy table syntax
Raw
mysql-copy-table-syntax
CREATE TABLE IF NOT EXISTS new_table LIKE existing_table;
INSERT new_table SELECT * FROM existing_table;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment