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