mysql中可以行转列。通过group_concat()函数。
如:select status,group_concat(bill_num) from mall_member_order group by status;
将bill_num列的值转化为一行,默认用,隔开
要设置指定的间隔符号,如下所示,指定用&隔开
select status,group_concat(name separator '&') from mall_member_order group by status;
mysql中可以行转列。通过group_concat()函数。
如:select status,group_concat(bill_num) from mall_member_order group by status;
将bill_num列的值转化为一行,默认用,隔开
要设置指定的间隔符号,如下所示,指定用&隔开
select status,group_concat(name separator '&') from mall_member_order group by status;