mysql - PHPMyAdmin - 内置编辑查询失败

Question

每当我在 PHPMyAdmin 上按下 Edit 键时，我都会收到以下错误:

#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 'LIMIT 0, 30' at line 1

它引用的查询是 PHPMyAdmin 的内置函数，所以我不明白为什么会失败。这是下面的查询:

SELECT * FROM `self`.`Condition` WHERE LIMIT 0, 30 

Answer 1

你的语法有错误。试试这个

SELECT * FROM `table-name` WHERE `Condition` LIMIT 0, 30

示例

SELECT * FROM `Orders` WHERE `company-name="HP"` LIMIT 0, 30