Rename or change name of MySQL table
Contributed by qmchenry 
July 4, 2006 
Tagged: MySQL
If you change your mind and want to rename an existing MySQL table, with or without data in it, it is no problem. One simple command will change the table’s name.
To change the name of an existing table first to second, use this command as a user with adequate privileges:
RENAME TABLE first TO second;
It is good DBA manners to make sure that no one and no program are using this table before making the name change.
Add New Comment
Viewing 3 Comments
Thanks. Your comment is awaiting approval by a moderator.
Do you already have an account? Log in and claim this comment.
Do you already have an account? Log in and claim this comment.
Do you already have an account? Log in and claim this comment.
Do you already have an account? Log in and claim this comment.
Add New Comment