GROUP_CONCAT修改默认长度

最新推荐文章于 2024-06-03 20:33:05 发布

东宇科技

最新推荐文章于 2024-06-03 20:33:05 发布

阅读量415

点赞数 1

文章标签：数据库 java sql

本文链接：https://blog.csdn.net/ldy889/article/details/127107414

版权

-- SET GLOBAL group_concat_max_len=102400;
-- SET SESSION group_concat_max_len=102400;
只有1024，超过会被截取

-- SELECT GROUP_CONCAT(id) from hst_exam_a177_report1 r1 RIGHT JOIN
-- ( SELECT mobile,subject_id ,COUNT(id) c from hst_exam_a177_report1 GROUP BY mobile,subject_id HAVING COUNT(id)>1 ) r2 on r1.mobile=r2.mobile and r1.subject_id=r2.subject_id
-- where r1.p is NULL
-- order by id
--
-- DELETE from hst_exam_a177_report1 where id in (6521,6526,6528,6530,6531,6533,6534,6535,6536,6537,6538,6540,6544,6545,6546,6547,6550,6551,6552,6553,6555,6556,6557,6558,6563,6564,6566,6568,6569,6571,6573,6574,6575,6577,6578,6580,6581, ,8259,8263,8276,8283,8284,8296,8297,8309,8315,8318,8322,8326,8327,8329,8332,8341,8348,8351,8354,8355,8357,8360,8361,8371,8388,8425,8428,8431,8440,8460,8465,8469,8489,8500,8505)
--