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;