我想从SQL中收集过go 30天的数据.
$result = $dbh->query('SELECT country,COUNT(*) FROM data_able GROUP BY country');
这不显示任何内容,而是显示最近30天的数据.
$result = $dbh->query('SELECT country,COUNT(*) FROM data_able GROUP BY country WHERE dtime > DATE_SUB(CURDATE(), INTERVAL 30 DAY)');
所有SQL条目都是在过go 30天内生成的.
$result = $dbh->query('SELECT country,COUNT(*) FROM data_able WHERE dtime > DATE_SUB(CURDATE(), INTERVAL 30 DAY) GROUP BY country');
What am I doing wrong here ?