Mysql学习手记
陆理手记
求学问是,敢为人先
展开
-
mysql对同一张表进行查询和赋值更新
You can't specify target table 'tb_user' for update in FROM clause ,mysql对同一张表进行查询和赋值更新原创 2017-07-13 16:02:40 · 4056 阅读 · 0 评论 -
mysql 1055的解决方案
我自己用的MySQL版本为5.7.11,同事用的5.6版本,代码从远程服务器上拉下来后运行,mybatis查询时报错,mysql 提示:[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column '字段名' which is not fun原创 2017-09-12 12:47:53 · 975 阅读 · 0 评论