mysql - 我想获取 2 个日期之间的数据，但显示 1064 错误

Question

我的 mysql 查询是

SELECT
  testid,  
  testName, 
  DATE(testviewaudit.datetime) ,
  SUM(action=1) AS view, 
  SUM(action=2) AS start, 
  SUM(action=3) AS finish 
FROM testviewaudit 
INNER JOIN tmtests 
ON estviewaudit.testid = tmtests.tsid  
WHERE DATE(testviewaudit.datetime) >= '2016-03-12' 
AND DATE(testviewaudit.datetime) <= '2016-03-15'
GROUP BY testid;

使用上述查询时，我收到 1064 错误

Answer 1

您只需在查询之间使用

 SELECT
    testid,
    testName,
    DATE(testviewaudit.datetime),
    SUM(action = 1) AS view,
    SUM(action = 2) AS start,
    SUM(action = 3) AS finish
  FROM testviewaudit INNER JOIN tmtests ON estviewaudit.testid = tmtests.tsid
  WHERE DATE(testviewaudit.datetime) between '2016-03-12'
	AND  '2016-03-15' GROUP BY testid;