使用SQL语句重命名MySQL表 [英] Rename a MySQL table using SQL statement

问题描述

我想使用SQL语句重命名现有表:

I want to rename an existing table using SQL statement:

我已经尝试过:

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

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

使用3条语句中的任何一条，我总是得到相同的错误消息:

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

您的SQL语法有误；请查看与您的MySQL服务器版本相对应的手册以获取正确的语法"

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

请告诉我我做错了！

推荐答案

尝试改用反引号，例如:

Try using backquotes instead, e.g.:

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

这篇关于使用SQL语句重命名MySQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！