mysql 常用
when
select x, case x when 'xx' then 'xx' when 'xxx' then 'xxx' end from x
左外连接
select a.x,b.xx ,
GROUP_CONCAT(
DISTINCT b.xxx','
)
from x a left join b on a.id=b.id where a.id=1 group byax .x,b.x
UNION ALL
GROUP_CONCAT(
...
原创
2021-03-18 17:26:45 ·
68 阅读 ·
0 评论