MySQL 语句长度过长怎么办

把这个值调大即可：max_allowed_packet

​
//查看max_allowed_packet值
show global variables like 'max_allowed_packet';    

//修改当前max_allowed_packet值
set session max_allowed_packet=2*1024*1024*10; 
​
//修改全局max_allowed_packet值
set global max_allowed_packet=2*1024*1024*10;

如果报错出现 1055 报错码，请看这篇文章：

MySQL 报错[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregat_小洪帽i的博客-CSDN博客

版权声明：本文为qq_39408664原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。