Rename a MySQL table using SQL statement

Issue

I want to rename an existing table using SQL statement:

I have already tried:

1. mysql_query("RENAME '$renameFolder' TO '$newName'");
2. mysql_query("ALTER TABLE '$renameFolder' RENAME TO '$newName'");
3. mysql_query("RENAME TABLE '$renameFolder' TO '$newName'");

Using any of the 3 statements I’m always getting the same error message:

“You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax”

Please tell me what I’m doing wrong!

Solution

Try using backquotes instead, e.g.:

mysql_query( "RENAME TABLE `" . $renameFolder . "` TO `" . $newname . "`" );

Answered By – Overv

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0