質問編集履歴
2
誤字
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -1,7 +1,7 @@
|
|
|
1
1
|
□目的:
|
|
2
2
|
group concatを使用して、ユーザーに付いているタグを並べたい
|
|
3
3
|
|
|
4
|
-
□
|
|
4
|
+
□error内容:
|
|
5
5
|
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'name FROM users INNER JOIN uts ON users.id = uts.user_id INNER JOIN ' at line 8
|
|
6
6
|
|
|
7
7
|
□sql文:
|
1
文字修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -8,9 +8,6 @@
|
|
|
8
8
|
SELECT
|
|
9
9
|
users.id,
|
|
10
10
|
users.username,
|
|
11
|
-
users.answer_count,
|
|
12
|
-
users.question_count,
|
|
13
|
-
users.last_visit,
|
|
14
11
|
users.created,
|
|
15
12
|
group_concat ( tags.name separator ',' ) AS name
|
|
16
13
|
FROM
|
|
@@ -22,7 +19,6 @@
|
|
|
22
19
|
WHERE
|
|
23
20
|
tags.category_id = '14'
|
|
24
21
|
OR tags.category_id = '2'
|
|
25
|
-
AND users.role = 'user'
|
|
26
22
|
GROUP BY
|
|
27
23
|
users.id
|
|
28
24
|
;
|