![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
家有两宝,感恩遇见
专注于java开发,按质按量按时完成工作,没有多余的话语,对职位不感兴趣,只对金钱感兴趣。
展开
-
mysql误操作后如何回复数据
mysql误操作回滚原创 2022-08-01 17:22:08 · 1346 阅读 · 0 评论 -
mybatis批量update报错 (mysql)
mybatis批量update报错 (mysql)原创 2022-01-26 17:47:26 · 1414 阅读 · 0 评论 -
MySQL数据库备份到本地计算机
一:bat文件@echo offset "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"D:\mysql\mysql-8.0.26-winx64\bin\mysqldump --opt -u root --password=hzz123456 vhr> F:\backup\vhr_%Ymd%.sql@echo on--------------------------------------------------------------------------原创 2021-10-14 16:37:01 · 559 阅读 · 0 评论 -
根据年度、季度、月份查询统计数据
一:sql语句select date_format(sale_date, '%Y') as nian,count(id) as num from card group by nian;select CONCAT(YEAR(sale_date),'-',quarter(sale_date)) jidu,count(id) as num from card group by jidu;select date_format(sale_date, '%Y-%m') as yue,count(id) as..原创 2020-11-27 15:53:45 · 542 阅读 · 0 评论 -
mysql根据多个字段按照固定顺序排序
1.根据cstate的4,5,7,1,2,3顺序排序语句:SELECT c.cstate,c.mc_1 from s_c c where c.cstate in(1,2,3,4,5,7) ORDER BY FIELD(c.cstate,4,5,7,1,2,3);结果:2.根据cstate的4,5,7,1,2,3和mc_1的3,2,1顺序排序语句:SELECT c.cstat...原创 2018-11-20 21:32:46 · 3301 阅读 · 0 评论