mysqlクエリー毎週毎月のデータメソッド

毎日のデータを問い合わせる:

SELECT
	COUNT(1) AS countNumber,
	DATE_FORMAT(createTime,'%Y-%m-%d') AS dateTime
FROM
	testTable
GROUP BY DATE_FORMAT(createTime,'%Y-%m-%d')

毎週のデータの照会:

SELECT
	COUNT(1) AS countNumber,
	WEEK(createTime) as dateTime
FROM
	testTable
GROUP BY WEEK(createTime) 

毎月のデータの照会:

SELECT
	COUNT(1) AS countNumber,
	MONTH(createTime) as dateTime
FROM
	testTable
GROUP BY MONTH(createTime)

毎年のデータを問い合せます.

SELECT
	COUNT(1) AS countNumber,
	YEAR(createTime) as dateTime
FROM
	testTable
GROUP BY YEAR(createTime)

その他:
DATE_ADD(createTime,INTERVAL 1 DAY)指定された日付の翌日の日付を得る／1を任意の数字に変更すれば翌日の日付を得ることができる
DATE_SUB(createTime,INTERVAL 1 DAY)指定日前日の日付を得る/1を任意の数字に変更するとN日前の日付が得られる
変数クエリーの宣言:
SET @counter=0; select @counter:=@counter+1 as id,count(*) as num FROM testTable ORDER BY num desc