質問編集履歴
3
誤字
test
CHANGED
File without changes
|
test
CHANGED
@@ -18,7 +18,7 @@
|
|
18
18
|
|
19
19
|
price
|
20
20
|
|
21
|
-
|
|
21
|
+
|code|user_id|price|
|
22
22
|
|
23
23
|
|:--|:--:|--:|
|
24
24
|
|
2
誤字
test
CHANGED
File without changes
|
test
CHANGED
@@ -4,7 +4,7 @@
|
|
4
4
|
|
5
5
|
user
|
6
6
|
|
7
|
-
|
|
7
|
+
|code|name|
|
8
8
|
|
9
9
|
|:--|:--:|
|
10
10
|
|
1
文章追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -74,6 +74,20 @@
|
|
74
74
|
|
75
75
|
|
76
76
|
|
77
|
+
```ここに言語を入力
|
78
|
+
|
79
|
+
SELECT user.name, reward.user_id, SUM(reward.reward) FROM user JOIN reward ON user.code=reward.user_id GROUP BY user.name LIMIT 0, 30
|
80
|
+
|
81
|
+
```
|
82
|
+
|
83
|
+
```ここに言語を入力
|
84
|
+
|
85
|
+
#1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.reward.user_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
|
86
|
+
|
87
|
+
```
|
88
|
+
|
89
|
+
|
90
|
+
|
77
91
|
|
78
92
|
|
79
93
|
### 試したこと
|
@@ -103,3 +117,13 @@
|
|
103
117
|
わかる方いましたら、教えていただけると幸いです。
|
104
118
|
|
105
119
|
よろしくお願いします。
|
120
|
+
|
121
|
+
|
122
|
+
|
123
|
+
|
124
|
+
|
125
|
+
### 補足情報(FW/ツールのバージョンなど)
|
126
|
+
|
127
|
+
|
128
|
+
|
129
|
+
MySQLを使っています。
|