07 2021 档案

摘要:select count(*) from sys_dept where find_in_set("T0001", ancestors) or dept_id="T0001" select count(*) from sys_dept where ancestors like concat('%', 阅读全文
posted @ 2021-07-28 10:47 northli 阅读(89) 评论(0) 推荐(0)
摘要:1. select replace(uuid(), '-', ''); 2. mysql循环函数和变量声明,相加, 不同mysql版本函数头不一样 function `20wdata(count int) return varchar(100)` begin declare i int; decla 阅读全文
posted @ 2021-07-26 19:27 northli 阅读(292) 评论(0) 推荐(0)
摘要:String str = "aaa,bbb,ccc,ddd,";String[] strArray = str.split(",");System.out.println(strArray); 阅读全文
posted @ 2021-07-25 14:54 northli 阅读(376) 评论(0) 推荐(0)
摘要:截取第二个 '.' 之前的所有字符。 select substring_index('www,sqlstudy,com,cn', ',', 2); 参考自 https://blog.csdn.net/mlks_2008/article/details/3983981?utm_medium=distr 阅读全文
posted @ 2021-07-25 12:08 northli 阅读(318) 评论(0) 推荐(0)
摘要:1. IDEA settings--> Compiler --> Make project automatically 选项勾选 转载自:https://www.cnblogs.com/duaner92/p/10833798.html 阅读全文
posted @ 2021-07-23 11:29 northli 阅读(314) 评论(0) 推荐(0)
摘要:ctrl+alt+左箭头/右箭头 阅读全文
posted @ 2021-07-15 15:08 northli 阅读(610) 评论(0) 推荐(0)
摘要:1. 2. 阅读全文
posted @ 2021-07-14 17:02 northli 阅读(162) 评论(0) 推荐(0)
摘要:默认的consoleas Size:16 line spacing:1.25 阅读全文
posted @ 2021-07-13 18:34 northli 阅读(90) 评论(0) 推荐(0)
摘要:K8S环境: 阅读全文
posted @ 2021-07-12 13:58 northli 阅读(32) 评论(0) 推荐(0)
摘要:INSERT INTO `zbc_jssltj2`.`zb_carry_info_collect_unit`(`id`, `zb_code`, `zb_name`, `ssdw_id`, `ssdw`, `ssfd_id`, `ssfd`, `sccj`, `ccrq`, `ccpc`, `zbsl 阅读全文
posted @ 2021-07-08 16:26 northli 阅读(185) 评论(0) 推荐(0)
摘要: 阅读全文
posted @ 2021-07-08 10:33 northli 阅读(1230) 评论(0) 推荐(0)
摘要:1.迅捷PDF转换器 2.360杀毒 3.js收藏夹 4.beyond compared 5.winrar 阅读全文
posted @ 2021-07-07 15:47 northli 阅读(44) 评论(0) 推荐(0)
摘要:1.红框是m,设置jetty启动, 2. spring boot 启动 阅读全文
posted @ 2021-07-07 11:17 northli 阅读(170) 评论(0) 推荐(0)