查询表中一个字段用逗号分隔的结果集,sql server 和 mysql的写法区别
sql server :
select LEFT(t,LEN(t)-1) from ( select (select CAST(group_module AS varchar(255)) +' ,' from group_module where for xml path('')) as t) temp;
mysql:
select group_concat(group_module) from group_module;
sql server :
select LEFT(t,LEN(t)-1) from ( select (select CAST(group_module AS varchar(255)) +' ,' from group_module where for xml path('')) as t) temp;
mysql:
select group_concat(group_module) from group_module;