Mysql函数实战

1.group_concat

场景:一对多的查询,电影有多个类型,把多个类型拼装到一条电影语句查询里面

sql:

SELECT
  f.id,
  f.name,
  f.english_name,
  f.filmStatus,
  group_concat(t.name SEPARATOR ',')
FROM jk_film f
  , relation r
  , jk_type t
WHERE r.src = f.id AND r.dst = t.id AND f.status = 1 AND r.status = 1 AND t.status = 1 AND t.category = 1 AND
      r.relationType = 14
GROUP BY f.id