数据库
笨小孩xl
这个作者很懒,什么都没留下…
展开
-
mysql varchar 转int排序
【代码】mysql varchar 转int排序。原创 2023-02-01 14:43:20 · 193 阅读 · 0 评论 -
添加索引方法
alter table messages add index idx_targetuserid (targetuserid);原创 2022-05-18 09:24:28 · 204 阅读 · 0 评论 -
查询一个时间段是否在另一个时间段内
只要有一个时间在此区间内就符合 SELECT starttime,endtime FROM businessapply WHERE deptguid = '1' and ( '2022-02-22'<=endtime and '2022-02-24'>=starttime) or('2022-02-22'>endtime and '2022-02-24'<starttime)原创 2022-02-21 15:09:11 · 1044 阅读 · 0 评论 -
mysql从一个随机选择10 条数据
SELECT * FROM frame_user ORDER BY RAND() LIMIT 10原创 2021-11-18 15:55:28 · 895 阅读 · 0 评论 -
2021-06-30
//附件名字校验 function onBeforeFileQueued (e){ var fileName = e.file.name.replaceAll( ".png","").replaceAll(".jpg", ""); console.log(fileName) console.log(!regtest(fileName)) if (!regtest(fileName)) { top.epoi...原创 2021-09-24 10:36:27 · 69 阅读 · 0 评论 -
列转行
基础SELECT NAME, MAX( CASE WHEN course = '语文' THEN score END ) AS 语文, MAX( CASE WHEN course = '数学' THEN score END ) AS 数学, MAX( CASE WHEN course = '英语' THEN score END ) AS 英语FROM studentGROUP BY NAMESELECT areac原创 2020-11-26 09:28:33 · 156 阅读 · 0 评论 -
如何将Oracle中同一列的多行记录拼接成一个字符串
关键字wm_concat SELECT PROJECT, wm_concat (DETAIL_NAME) DETAIL_NAME FROM ( SELECT PR. PROJECT, PR.DETAIL_NAME || DETAI_NUM || UNIT DETAIL_NAME FROM PRJ_T_TENDAYS_PROJECT_REPORT PR ) A GROUP BY PROJECT原创 2020-05-21 10:58:23 · 492 阅读 · 0 评论 -
oracle 树形查询
https://www.cnblogs.com/always-online/archive/2015/10/30/4923532.html原创 2019-12-13 14:28:17 · 89 阅读 · 0 评论