From c61573b7222a99a69ff381fac53f4af831030830 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 09 一月 2023 13:46:30 +0800
Subject: [PATCH] 2

---
 data/update.sql |   12 ++++++++----
 1 files changed, 8 insertions(+), 4 deletions(-)

diff --git a/data/update.sql b/data/update.sql
index 71ccaa6..3aedf7b 100644
--- a/data/update.sql
+++ b/data/update.sql
@@ -105,11 +105,15 @@
 select zoning from lf.sys_coord group by zoning;
 select id, name from lf.sys_dir where pid = 0 and id > 1;
 
+select * from lf.sys_coord where epsgcode = 'EPSG:4490';
+select * from lf.sys_operate;
 
-
-
-
-
+with recursive rs as(
+	select a.*, fullName from lf.sys_dir a where name=#{name}
+union
+	select a.* from lf.sys_dir a, rs b where a.pid=b.id
+)
+select * from rs order by order_num;
 
 
 

--
Gitblit v1.9.3