(mysql笔记)GROUP_CONCAT() 把多行数据合并
不合并查询:
合并查询:
SELECT GROUP_CONCAT(id) FROM orderinfo WHERE enterpriseid = 2265 AND shopid =0 AND orderstatus =30
不合并查询:
合并查询:
SELECT GROUP_CONCAT(id) FROM orderinfo WHERE enterpriseid = 2265 AND shopid =0 AND orderstatus =30