![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MYSQL
czx33859066
这个作者很懒,什么都没留下…
展开
-
mysql Row_number()分组排序函数
1.mysql8.0的版本才有这个函数MySQL8.0 :select sales_name , sum(sales) ,Row_number() OVER(ORDER BY sum( sales)DESC) as 'rank' from spm_ordergroup by sales_name2.mysql5.7需要另外一种写法MySQL5.7:#@变量名=赋值只要使用变量必须加@@rank:=@rank + 1每查询到一条结果,就会进行+1SET@rank= 0;select A原创 2021-07-01 15:21:39 · 660 阅读 · 0 评论 -
MYSQL对单表的导入导出
导入load data infile 'e:\a.txt' into table tableA character set utf8 fields terminated by ',' enclosed by '"' lines terminated by '\r\n' ;导出select * from tableA into outfile 'e:\a.txt' fields原创 2013-05-16 15:00:59 · 2883 阅读 · 0 评论