Saturday 20 May 2017

How To Rename a Table in MySQL?

To rename a table in MySQL you just need to run a command named RENAME TABLE
RENAME TABLE tb1 TO tb2;
The RENAME TABLE command will rename the table atomically, which means your table will be locked during the command.

No comments:

Post a Comment

Advertisement

Advertisement