Mysql语法似乎正确

Question

所以...我收到了:

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 'key = '48f9f4a3f5e10c63804400f320f46e26'' at line 1

所以我把它反射(reflect)给自己，在网页上写着:

SELECT * FROM email_confirm WHERE email = 'censored@gmail.com' AND key = '48f9f4a3f5e10c63804400f320f46e26'

我没有看到这个问题。

MySQL版本为5.1.65-cll

回答: KEY是mysql中的保留字。需要 反引号 !

Answer 1

key 是一个 MySQL 关键字。由于它也是您的字段名称，因此请用适当的符号将其括起来:

SELECT * FROM `email_confirm` WHERE `email` = 'censored@gmail.com' AND `key` = '48f9f4a3f5e10c63804400f320f46e26';