From 6e15fb58d1530c5dc28be872f950b2d5758246f8 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期日, 27 十一月 2022 08:50:48 +0800 Subject: [PATCH] 1 --- data/db_fn.sql | 22 ++++++++++------------ 1 files changed, 10 insertions(+), 12 deletions(-) diff --git a/data/db_fn.sql b/data/db_fn.sql index dc71fd9..c634d60 100644 --- a/data/db_fn.sql +++ b/data/db_fn.sql @@ -339,8 +339,9 @@ select ST_AsText(geom) from bd.dlg_25w_resa limit 1; -- MultiLineString MultiPolygon Point -select GeometryType(geom) from bd.dlg_25w_boul; -select st_srid(geom) from bd.dlg_25w_boul limit 1; +select GeometryType(geom) from bd.dlg_25w_boul where gid=20; +select st_srid(geom) from bd.dlg_25w_boul where gid=20 limit 1; +select ST_AsText(geom) from bd.dlg_agnp where gid=20; select * from lf.sys_dict where ns='bd' and tab='dlg_25w_boul' and field='geom'; select * from lf.sys_meta; -- delete from lf.sys_meta; @@ -348,17 +349,14 @@ select * from lf.sys_meta_file a where metaid in (99,100,101) alter sequence bd.dlg_agnp_gid_seq restart with 4000; -select * from bd.dlg_agnp; +select max(gid) from bd.dlg_agnp; +--to_char(now(),'yyyy-mm-dd hh24:MI:SS') +select create_time,to_char(create_time,'yyyy-mm-dd hh24:mi:ss') from lf.sys_menu where id=1; -select tab,count(*) from lf.sys_dict d where field='classes' group by tab order by tab - - - - - - - - +select * from bd.dlg_25w_boul where gid<11; -- delete from bd.dlg_25w_boul where gid>10; alter sequence bd.dlg_25w_boul_gid_seq restart with 20; +select * from bd.dlg_25w_resa where gid<12; -- delete from bd.dlg_25w_resa where gid>11; alter sequence bd.dlg_25w_resa_gid_seq restart with 20; +select * from bd.dlg_agnp where gid<13; -- delete from bd.dlg_agnp where gid>12; alter sequence bd.dlg_agnp_gid_seq restart with 20; +select gb,name,classes,pinyin,pac,bsm,geom,eventid,dirid,depid,verid,createtime,createuser,updateuser,updatetime from bd.dlg_agnp -- Gitblit v1.9.3