![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mysql
文章平均质量分 75
你算哪块小饼干咯
Error
展开
-
JAVA-You can change this value on the server by setting the ‘max_allowed_packet‘ variable.
上传图片把数据存储到数据库时,报错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 .原创 2022-03-29 15:37:45 · 889 阅读 · 0 评论 -
JAVA-根据每年/每月/每日做数据统计,并给空数据补0
我这边先展示下需求大概是什么样的:根据时间区间,展示每个节点的数据,形成曲线图。我的第一种方法是用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原创 2021-10-20 16:52:37 · 5018 阅读 · 1 评论