我有以下查询:
select card.id as id, photo.image as photo
from card
left outer join card_image as photo on (photo.card=card.id)
返回的是
+----+-------+
| id | photo |
+----+-------+
| 1 | 2 |
| 1 | 3 |
| 1 | 4 |
| 2 | 5 |
| 2 | 6 |
+----+-------+
如果我将
photo.image as photo
更改为group_concat(photo.image) as photos
,则会得到以下结果。+----+---------------+
| id | photo |
+----+---------------+
| 1 | 2,3,4,5,6 |
+----+---------------+
但是我的期望是:
+----+-----------+
| id | photo |
+----+-----------+
| 1 | 2,3,4 |
| 2 | 5,6 |
+----+-----------+
我想通过id获取每张卡片的一组照片。