![](https://img-blog.csdnimg.cn/20190927151124774.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
Mysql数据库
Mysql数据库相关
fzhu008
这个作者很懒,什么都没留下…
展开
-
mysql查询最近十年
SELECT EXTRACT(YEAR FROM NOW()) YEAR UNION SELECT EXTRACT(YEAR FROM NOW()) -1 YEAR UNION SELECT EXTRACT(YEAR FROM NOW()) -2 YEAR UNION SELECT EXTRACT(YEAR FROM NOW()) -3 YEAR UNION SELECT EXTRACT(Y...原创 2020-02-19 11:08:02 · 1175 阅读 · 0 评论 -
mysql 查询最近12个月日期
SELECT EXTRACT(YEAR_MONTH FROM NOW()) yearmonth UNION SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 1 MONTH)) yearmonth UNION SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 2 MONTH)) ...原创 2020-02-19 11:06:53 · 1130 阅读 · 1 评论 -
mysql 查询本年度所有月份
SELECT DATE_FORMAT(DATE_ADD( CONCAT(YEAR(DATE(‘2018-12-01’)),’-01-01’),INTERVAL (CAST( help_topic_id AS SIGNED INTEGER )) MONTH ),’%m’) month FROM mysql.help_topic WHERE help_topic_id < 12 ORDER BY...原创 2020-02-19 11:04:56 · 4298 阅读 · 0 评论