mysql
Diamond_yoyo
这个作者很懒,什么都没留下…
展开
-
MySQL执行sql报错MySQL server has gone away
MySQL执行sql报错MySQL server has gone away原创 2022-07-06 14:05:15 · 617 阅读 · 0 评论 -
mysql将俩个SQL查询出来的不一样的结果横向拼接成一行数据
select t1.*,t2.*,t3.* from (select......) as t1,(select.....) as t2,(select.....) as t3原创 2020-08-05 11:42:30 · 4067 阅读 · 2 评论 -
运行SQL文件时报Lost connection to MySQL server during query
步骤1:参考https://www.jianshu.com/p/98c7a63b84c3步骤2:参考https://blog.csdn.net/weixin_39561473/article/details/90213914直接在Navicat中运行sqlset global net_read_timeout = 120;set global net_write_timeout = 900;原创 2020-06-19 17:10:43 · 526 阅读 · 0 评论 -
mysql升级到5.7版本后,运行程序报错this is incompatible with sql_mode=only_full_group_by
升级mysql后,运行程序报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘......’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by尝试原创 2020-06-19 14:39:10 · 307 阅读 · 0 评论