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