MySQL表名称中的特殊字符 [英] Special Characters in MySQL Table Name

问题描述

我创建了一个表，如下所示:

I created a table as follows:

CREATE TABLE IF NOT EXISTS 'e!' (
`aa` int(11) unsigned NOT NULL auto_increment,
`showName` TEXT NOT NULL default '',
`startDateTime` DATETIME NOT NULL default '',
`endDateTime` DATETIME NOT NULL default '',
PRIMARY KEY  (`aa`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8

然后尝试插入查询:

INSERT INTO e! (showname, startDateTime, endDateTime) VALUES('E! News ', '2012-05-03 19:00:00', '2012-05-03 20:00:00')

并且由于表名中的!而导致错误，我假设!是mysql中的特殊字符.我试图对其进行转义，但查询仍然失败.

And it errors due to the ! in the table name, I'm assuming ! is a special character in mysql. I tried to escape it but the query still failed.

那么，表名称中可以有诸如!或&之类的特殊字符吗?如果是，那么我可能必须以某种方式对其进行编码?

So, can I have special characters like ! or & in the table name? If yes, then I probably have to encode them somehow?

谢谢.

推荐答案

用反引号括住您的歧义表或特殊"表名:

Quote your ambiguous or "special" table names with a back tick:

INSERT INTO `e!` ...

或者更好的做法是，不要在表名中使用特殊字符，以免出现此类问题.

Or better, don't use special characters in table names to avoid such problems.

这篇关于MySQL表名称中的特殊字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！