| | |
| | | select * from lf.sys_dict where field='gid'; |
| | | select field,type,count(*) from lf.sys_dict where field='gid' group by field,type; |
| | | update lf.sys_dict set type='integer' where field='updateuser'; |
| | | |
| | | select * from lf.sys_layer; |
| | | alter sequence lf.sys_layer_id_seq restart with 1; |
| | | select * from lf.sys_dict where ns='md'; |
| | | |
| | | select * from lf.sys_menu where position('http:' in url)>0; |
| | | select * from bd.b_hydrogeology_attach limit 1; |
| | |
| | | |
| | | select * from lf.sys_serve_log; |
| | | select * from lf.sys_meta; |
| | | select * from lf.sys_operate order by id limit 20; |
| | | select * from lf.sys_operate order by id desc limit 20; |
| | | |
| | | select modular1,modular2,count(*) from lf.sys_operate group by modular1,modular2 order by modular1 desc,modular2; |
| | | |
| | | select type from lf.sys_operate group by type |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |