数据库
徐川江的个人博客
这个作者很懒,什么都没留下…
展开
-
mysql的only_full_group_by
点击统计分析时突然交易统计报错,原来一直正常,看了错误代码,发现mysql报错,错误代码如下: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXX.T_XXX.PAY_FINISH_DATE' which is not functionally depende...原创 2016-11-14 16:00:08 · 3349 阅读 · 0 评论 -
MySQL不支持子查询里有limit解决办法
这样的语句是不能正确执行的。 select * from table where id in (select id from table limit 10); 但是,只要你再来一层就行。。如: select * from table where id in (select t.id from (select * from table limit 10)as t)...原创 2018-11-06 14:46:03 · 2734 阅读 · 0 评论 -
sqoop连接mysql提示Your password has expired
使用sqoop连接mysql5.7出现错误: Your password has expired. To log in you must change it using a client that supports expired passwords 意思大致是说密码过期,进入Mysql通过命令: select password_expired,User from User 查看密码是...原创 2018-11-20 19:43:58 · 518 阅读 · 1 评论