Mysql
海蓝遇到鲸
这个作者很懒,什么都没留下…
展开
-
mysql 日期相关查询
【代码】mysql 日期相关查询。原创 2022-12-01 15:46:57 · 1386 阅读 · 2 评论 -
activiti视图查询待办
activiti视图查询待办SELECT `a`.`ID_` AS `TASK_ID`, `a`.`PROC_INST_ID_` AS `PROC_INST_ID`, `a`.`PROC_DEF_ID_` AS `PROC_DEF_ID_`, `a`.`TASK_DEF_KEY_` AS `ACT_ID`, `a`.`NAME_` AS `ACT_NAME`, `a`.`ASSIGNEE_` AS `ASSIGNEE`, `a`.`DELEGATION_` AS `DELEGATION_ID原创 2022-02-28 15:52:15 · 280 阅读 · 0 评论 -
Mysql
Mysql 单列按符号分隔为多条数据select a.id,substring_index(substring_index(a.name,’,’,b.help_topic_id+1),’,’,-1) namefrom test a joinmysql.help_topic bon b.help_topic_id < (length(a.name) - length(replace(a.name,’,’,’’))+1)order by a.id;原链接...原创 2020-10-15 10:12:16 · 67 阅读 · 0 评论