MySQL Prepare 语句语法

Question

我无法让我的 prepare 语句在 MySQL 5.6.14 中运行；这是有问题的代码块:

SET @backupDate = DATE(NOW());
SET @renameTable = CONCAT('RENAME TABLE activeDirectoryData TO actDirBackup-', @backupDate);
PREPARE goRenameTable FROM @renameTable;
EXECUTE goRenameTable;
DEALLOCATE PREPARE goRenameTable;

脚本在准备语句处停止，出现以下错误:

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-2013-11-06' at line 1

知道这里出了什么问题吗？

Answer 1

名称 actDirBackup- 的值来自 @backupDate 不是有效的表名，您必须将其转义，如下所示:

SET @renameTable = CONCAT('RENAME TABLE activeDirectoryData TO `actDirBackup-',
                          @backupDate, '`');