SELECT DATE_ADD('2024-02-01',INTERVAL(CAST(HELP_TOPIC_ID AS SIGNED INTEGER))DAY) temp_date
FROM MYSQL.HELP_TOPIC
WHERE HELP_TOPIC_ID <(to_days('2024-02-29')- to_days('2024-02-01'))+1ORDERBY HELP_TOPIC_ID
写法2:请求太慢了
SELECT*FROM(SELECT adddate('2020-01-01',t4.i *10000+ t3.i *1000+ t2.i *100+ t1.i *10+ t0.i) temp_date
FROM(SELECT0 i UNIONSELECT1UNIONSELECT2UNIONSELECT3UNIONSELECT4UNIONSELECT5UNIONSELECT6UNIONSELECT7UNIONSELECT8UNIONSELECT9) t0,(SELECT0 i UNIONSELECT1UNIONSELECT2UNIONSELECT3UNIONSELECT4UNIONSELECT5UNIONSELECT6UNIONSELECT7UNIONSELECT8UNIONSELECT9) t1,(SELECT0 i UNIONSELECT1UNIONSELECT2UNIONSELECT3UNIONSELECT4UNIONSELECT5UNIONSELECT6UNIONSELECT7UNIONSELECT8UNIONSELECT9) t2,(SELECT0 i UNIONSELECT1UNIONSELECT2UNIONSELECT3UNIONSELECT4UNIONSELECT5UNIONSELECT6UNIONSELECT7UNIONSELECT8UNIONSELECT9) t3,(SELECT0 i UNIONSELECT1UNIONSELECT2UNIONSELECT3UNIONSELECT4UNIONSELECT5UNIONSELECT6UNIONSELECT7UNIONSELECT8UNIONSELECT9) t4
) date_list
WHERE temp_date BETWEEN'2024-02-01'AND'2024-02-29'
写法3:外面传参数进来当临时表(推荐)
<selectid="listCompare"resultType="com.ruoyi.business.vo.TDeviceLogVo">SELECT A.temp_dateFROM (<foreachcollection="dateList"index="index"item="item"open="("separator="union"close=")">select #{item} as temp_date</foreach>) A
</select>
相关新闻
LLM(2) | 什么是 LLM
LLM(2) | 什么是 LLM
本文是对 What is a large language model (LLM)? 的翻译。 文章目录 LLM(2) | 什么是 LLM什么是大模型? (What is a large language model (LLM)?)LLM 被用来做什么? (What are LLMs used for?)LLM 的优势和局限性是什么? (What are som…
DataEase开源BI工具:如何在3分钟内做出明智的版本选择决策 【免费下载链接】dataease 🔥 人人可用的开源 BI 工具,数据可视化神器。An open-source BI tool alternative to Tableau. 项目地址: https://gitcode.com/GitHub_Trending/da/dat…
Xenia Manager未来路线图:即将推出的5大新功能预览
Xenia Manager未来路线图:即将推出的5大新功能预览 【免费下载链接】xenia-manager Xenia Manager is a tool that tries to make using Xenia Emulator easier. 项目地址: https://gitcode.com/gh_mirrors/xe/xenia-manager
Xenia Manager是一款旨在简化Xen…