Skip to content

Instantly share code, notes, and snippets.

@ken-muturi

ken-muturi/clone-msyql-table.sql

Created November 17, 2013 03:40
Show Gist options
  • Save ken-muturi/7508777 to your computer and use it in GitHub Desktop.
Save ken-muturi/7508777 to your computer and use it in GitHub Desktop.
Download ZIP
Clone a MYSQL table
Raw
clone-msyql-table.sql
CREATE TABLE newTableName
LIKE oldTableName
Raw
clone_table_with_data
CREATE TABLE newTableName
SELECT *
FROM oldTableName
@yussan
Copy link

yussan commented Sep 10, 2020

amazing

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment