oracle
盼超师兄
热爱游戏,热爱师妹
展开
-
ROW_NUMBER() OVER函数
select loginname, ROW_NUMBER() OVER(PARTITION BY D.file_flag ORDER BY D .file_date DESC) as RN from table where rn<5原创 2019-12-24 09:43:51 · 97 阅读 · 0 评论 -
linux安装mysql8
centOS7.6安装MySQL8 Navicat 连接MySQL 8.0.11 出现2059错误 ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost' 报错ERROR 1396 (HY000): Operation ALTER USER failed for 'root' 解决方法:...原创 2019-11-15 09:42:32 · 101 阅读 · 0 评论