To copy a table in MySQL you can use the following snippet.
Sample MySQL
CREATE TABLE NEWTABLE LIKE OLDTABLE; INSERT NEWTABLE SELECT * FROM OLDTABLE;
3 thought on “How to copy a table in MySQL”
Leave a Reply
You must be logged in to post a comment.
All the Code Snippets and Samples you need
To copy a table in MySQL you can use the following snippet.
CREATE TABLE NEWTABLE LIKE OLDTABLE; INSERT NEWTABLE SELECT * FROM OLDTABLE;
You must be logged in to post a comment.
RT @CodeSnippetsNET: How to copy a table in #MySQL http://t.co/9y1VTVXvJG #php #html #js #javascript #css #programming #code
RT @CodeSnippetsNET: How to copy a table in #MySQL http://t.co/9y1VTVXvJG #php #html #js #javascript #css #programming #code
RT @CodeSnippetsNET: How to copy a table in #MySQL http://t.co/9y1VTVXvJG #php #html #js #javascript #css #programming #code