group_concat函数长度有默认的长度限制,如果在使用数据查询的时候使用该函数,长度超过限制后会被截取。
SELECT
group_concat( t1.order_id ) AS order_ids,
sum( t1.amount ) AS sum_amount,
sum( t1.brokerage ) AS sum_brokerage
FROM
`faka_order` `t1`
INNER JOIN `faka_shop` `t2` ON `t1`.`shop_id` = `t2`.`shop_id`
WHERE
( `t1`.`status` = 1 AND ( bill_id IS NULL ) )
AND `t1`.`delete_at` IS NULL
GROUP BY
`t1`.`shop_id`
想要不被限制,可以修改group_concat函数的长度限制。
MySQL配置文件中修改
group_concat_max_len = 1024
发表回复
要发表评论,您必须先登录。