每当我在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
最佳答案
您的语法错误。尝试这个
SELECT * FROM `table-name` WHERE `Condition` LIMIT 0, 30
例
SELECT * FROM `Orders` WHERE `company-name="HP"` LIMIT 0, 30
关于mysql - PHPMyAdmin-内置的编辑查询失败,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/42271908/