Mysql: duplicating a table

You need to do :

CREATE TABLE newtable LIKE oldtable; 
INSERT newtable SELECT * FROM oldtable;

This creates copy of existing Mysql table with indexes

2016
03/15
CATEGORY
Новини
TAGS

Write comment

  1. No comments yet.

  1. No trackbacks yet.

You must be logged in to post a comment.