From f15c13bea9f5b47e4527ae9ec715c54602a9ae45 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 25 二月 2023 14:35:28 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index d4e9373..452884d 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -11,6 +11,7 @@
select uuid_generate_v4(); -- uuid锛�36浣�
select split_part('12.34.56.78', '.', 1); -- 鍒囧壊
select substr('FY2021', 3, 2); -- 鎻愬彇
+select substr('FY2021', 3); -- 鎻愬彇
select substring('FY2021' FROM 3 for 2); -- 鎻愬彇
select position('23' in 'w123456'); -- 浣嶇疆
select md5(''); -- MD5
@@ -325,9 +326,9 @@
select (select string_agg(code, ',') from lf.sys_dir where name = a.name) "key", name "value"
from lf.sys_dir a
-where name in ('DOM', 'DEM', 'DRG', 'DLG', '娴嬮噺锛圗SV锛�', 'OSM鏁版嵁', '鍩虹鍦扮伨', '鍩虹鍕樺療', '鍚堣鏁版嵁', '绠＄悊鏁版嵁', '鍕樺療锛圗GE锛�', '鍦扮伨锛圗GD锛�', '娲炲簱锛圗GD锛�')
+where name in ('鍩虹娴嬬粯', '鍩虹鍦扮伨', '鍩虹鍕樺療', '鍚堣鏁版嵁', '绠＄悊鏁版嵁', '娴嬮噺锛圗SV锛�', '鍕樺療锛圗GE锛�', '鍦扮伨锛圗GD锛�', '娲炲簱锛圗GD锛�')
group by name
-order by key
+order by key;
--
Gitblit v1.9.3