#1064 从表中删除项目时
我最近升级到 MYSQL 5。这是 webhost 允许的最新版本。当尝试更新表或删除条目时，这是我在 phpmyadmin 中收到的错误。
错误
您的 SQL 查询中似乎存在错误。下面的 MySQL 服务器错误输出（如果有）也可以帮助您诊断问题
ERROR: Unlated quote @ 101 STR：' SQL：DELETE FROM inmates WHERE inmates.counties_id = 33 AND CONVERT(inmates.link USING utf8) = \'http://inmate1.riversidesheriff.org/iis/\' LIMIT 1
SQL 查询：
DELETE FROM inmates
WHERE `inmates`.`counties_id` = 33
AND CONVERT(`inmates`.`link` USING utf8) = \'http://inmate1.riversidesheriff.org/iis/\'
LIMIT 1
MySQL 说：
文档#1064 - 您的 SQL 语法有错误；检查 与您的 MySQL 服务器版本相对应的手册 在 '\'http://inmate1.riversidesheriff.org/iis/\' LIMIT 附近使用的语法 1' 在第 1 行
，这是查询，
SELECT * FROM `inmates` WHERE 1
非常感谢任何帮助 谢谢。
I recently upgraded to MYSQL 5. That is latest version that webhost allows. When trying to update a table or delete an entry this is the error I receive while in phpmyadmin.
Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unclosed quote @ 101
STR: '
SQL: DELETE FROM inmates WHERE inmates.counties_id = 33 AND CONVERT(inmates.link USING utf8) = \'http://inmate1.riversidesheriff.org/iis/\' LIMIT 1
SQL query:
DELETE FROM inmates
WHERE `inmates`.`counties_id` = 33
AND CONVERT(`inmates`.`link` USING utf8) = \'http://inmate1.riversidesheriff.org/iis/\'
LIMIT 1
MySQL said:
Documentation #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 '\'http://inmate1.riversidesheriff.org/iis/\' LIMIT
1' at line 1
and here is the query
SELECT * FROM `inmates` WHERE 1
any help is greatly appreciated
thank you.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
去掉单引号前的反斜杠：它们不是必需的。
我的意思是，将其更改
为：
Lose the backslash before the single-quotes: they are not required.
By that I mean, change this:
To this: