我有一个包含许多记录的mysql表tbl_track。22:36September | September & October我尝试了一下,但结果是相反的,从本月到月初我还为每个人编写了单独的查询SELECT * FROM tbl_track
WHERE YEAR(`date_created`) = YEAR(CURRENT_DATE)AND MONTH(`date_crea
COUNT(DISTINCT ip) FROM visits_website WHERE YEAR(create_at) = YEAR(CURDATE())) AS total_year--这是我为所有访问所做的查询:
SELECTvisits_website WHERE YEAR(`create_at`) = YEAR(CURDATE()