phpadmin - mysql 修改数据库表名报错

Question

1. 我使用的sql语句是：
   RENAME TABLE "table 36" to "DW"

2. 贴上相关代码

3. 贴上报错信息

1. 贴上相关截图

2. 已经尝试过哪些方法仍然没解决（附上相关链接）

Answer 1

Try this

RENAME TABLE `table 36` to `DW`

Answer 2

Is there an extra space after table36?

Answer 3

Table names cannot be enclosed in double quotes. Generally, single quotes are used. It doesn’t matter. However, there are spaces in the middle of your table name. It is recommended to use single quotes