回答編集履歴
1
コード修正
test
CHANGED
@@ -4,7 +4,7 @@
|
|
4
4
|
|
5
5
|
FROM (
|
6
6
|
|
7
|
-
SELECT access_type,week(access_day,2) AS w, DATE_FORMAT(access_day,"%Y") AS y
|
7
|
+
SELECT access_type, access_day, week(access_day,2) AS w, DATE_FORMAT(access_day,"%Y") AS y
|
8
8
|
|
9
9
|
FROM access_record
|
10
10
|
|