Saturday, April 6, 2013

Copy table in MySQL, change table name in MySQL

To copy a table in MySQL, for example copy table users to new_users.
First we create  an empty table new_users with the same structure as users
create table new_users like users;
Then we insert new_users withe same content from users
INSERT new_users SELECT * FROM users;

To change table name in MySQL, for example new_users to new_users1
RENAME TABLE new_users TO new_users1;

No comments:

Post a Comment