How to rename a table in MySQL

March 23, 2018 4 sec read

RENAME TABLE oldTable TO newTable;

Replace oldTable with the table’s name that you want to rename and newTable with the new table name.

Last Updated On March 23, 2018

« How to drop a entire MySql Database on the command line in Linux

ERROR 1194 (HY000): Table ‘mytable’ is marked as crashed and should be repaired, how do I fix this? »

Leave a Reply

Subscribe