weixin_46690278的博客

上传图片把数据存储到数据库时,报错 Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (5,922,670 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable. ; Packet for query is too large .

我这边先展示下需求大概是什么样的: 根据时间区间,展示每个节点的数据,形成曲线图。 我的第一种方法是用mysql的函数: SELECT @a :=@a + 1 AS `index`, DATE_FORMAT(ADDDATE( #{startDate} ,INTERVAL @a DAY),'%Y-%m-%d') AS date FROM mysql.help_topic,(SELECT @a:=-1) temp WHE