mysql - 简单的 date_sub() mySQL 查询无法执行

Question

这是我尝试执行但无济于事的查询

SELECT 
    p.*, c.* 
FROM 
    `players` AS `p` 
INNER JOIN 
    `price_checks` AS `c` 
ON 
    `c`.`resourceId` = `p`.`Player_Resource` 
WHERE 
    DATE(`c`.`timecheck`) = DATE(DATE_SUB(NOW(), INTERVAL 1 DAY) 
AND 
    `p`.`Players_id` = '16892'

我所看到的错误如下

SELECT p.*, c.* FROM `players` AS `p` INNER JOIN `price_checks` AS `c` ON `c`.`resourceId` = `p`.`Player_Resource` WHERE DATE(`c`.`timecheck`) = DATE(DATE_SUB(NOW() , INTERVAL 1 DAY) AND `p`.`Players_id` = '16892' 
LIMIT 0, 25 
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, 25' at line 2 

它是说我要附加 LIMIT 语法？有什么原因可能会失败吗？

Answer 1

您缺少)

     DATE(`c`.`timecheck`) = DATE(DATE_SUB(NOW(), INTERVAL 1 DAY) )
                                                                  ^--here

原因: mysql正在寻找)，然后它出现了LIMIT，而)还没有出现，所以他很惊讶为什么 LIMIT 现在出现:)，然后它告诉你 ayyy，Heyy! LIMIT 右边是否缺少某些内容:)。 ？