15,076
edits
排除 MySQL 技術疑難問題: Difference between revisions
Jump to navigation
Jump to search
→錯誤 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
m (→SQL 查詢錯誤) |
|||
| Line 335: | Line 335: | ||
(2, 'A123', 'Bob', '推推', 5, '2024-01-02'), | (2, 'A123', 'Bob', '推推', 5, '2024-01-02'), | ||
(3, 'A123', 'Bob', '讚讚', 3, '2024-01-03'); | (3, 'A123', 'Bob', '讚讚', 3, '2024-01-03'); | ||
-- 這會報錯 | |||
SELECT | |||
id, -- 問題: 沒有在 GROUP BY 中 | |||
post_id, | |||
author, | |||
GROUP_CONCAT(content SEPARATOR "\n") AS content, -- 問題: 沒有在 GROUP BY 中 | |||
likes -- 問題: 沒有在 GROUP BY 中 | |||
FROM posts | |||
GROUP BY post_id, author; | |||
</pre> | </pre> | ||