摘要: mac笔记本默认键盘左下角的布局从左往右是:control,option,command。 接入外接键盘后按键盘指引配置完,键位匹配默认为:ctrl = control,win = command,alt = option。 修改方式: 打开系统偏好设置 - 键盘- 修饰键,如图,调换option和 阅读全文
posted @ 2026-01-28 10:27 chenzechao 阅读(7) 评论(0) 推荐(0)
摘要: { "workbench.preferredHighContrastLightColorTheme": "Default Light Modern", // 显示所有空白字符(空格/Tab/换行符) "editor.renderWhitespace": "all", // 独立控制 Tab 显示(增 阅读全文
posted @ 2026-01-27 14:10 chenzechao 阅读(3) 评论(0) 推荐(0)
摘要: select * from ( select 1 as start,5 as end union all select 6 as start,10 as end union all select 11 as start,15 as end union all select 17 as start,2 阅读全文
posted @ 2026-01-21 15:45 chenzechao 阅读(2) 评论(0) 推荐(0)
摘要: 问题: 遇到一个奇怪的问题,SQL执行正常,但如果查询的时间段超过一个月则执行报错。 环境信息 select current_version() as version; -- 3.3.20-1.3.0-202512081638-7f00bc3 查询SQL如下 whit data_top as ( s 阅读全文
posted @ 2025-12-26 17:40 chenzechao 阅读(17) 评论(0) 推荐(0)
摘要: https://blog.csdn.net/m0_61066945/article/details/135181827 阅读全文
posted @ 2025-11-12 14:39 chenzechao 阅读(7) 评论(0) 推荐(0)
摘要: #获取ETL任务跑批开始日期[默认取上月1号] ETL_START_DATE="${ETL_START_DATE:-`date -d "${bizdate:0:6}01 - 1 months" +"%Y%m%d"`}" #获取ETL任务跑批结束日期[默认取T-1] ETL_END_DATE="${E 阅读全文
posted @ 2025-08-08 10:38 chenzechao 阅读(12) 评论(0) 推荐(0)
摘要: ![image](https://img2024.cnblogs.com/blog/986761/202508/986761-20250801133820953-625510952.png) 阅读全文
posted @ 2025-08-01 13:38 chenzechao 阅读(34) 评论(0) 推荐(0)
摘要: JDK11之后不再提供JRE下载包,可以由JDK生成,命令如下 bin/jlink --module-path "/usr/local/jdk17/jmods" --add-modules ALL-MODULE-PATH --output jre 阅读全文
posted @ 2025-07-25 15:29 chenzechao 阅读(129) 评论(0) 推荐(0)
摘要: ![image](https://img2024.cnblogs.com/blog/986761/202507/986761-20250722091247168-1382730217.png) 阅读全文
posted @ 2025-07-22 09:13 chenzechao 阅读(46) 评论(0) 推荐(0)
摘要: select @cnt_before := count(1) as cnt from api_log ; select @cnt_before as 'cnt_刷新前',count(1) as 'cnt_刷新后' from api_log limit 10; 阅读全文
posted @ 2025-07-16 09:25 chenzechao 阅读(10) 评论(0) 推荐(0)