每当我在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


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

最佳答案

您的语法错误。尝试这个

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/

10-13 06:48