| | |
| | | select * from lf.sys_dir |
| | | select * from lf.sys_meta order by id desc; --1062,1398 |
| | | |
| | | select * from lf.sys_apply |
| | | delete from lf.sys_apply where id=13 |
| | | select * from lf.sys_flow |
| | | delete from lf.sys_flow where applyid=13 |
| | | |
| | | |
| | | |
| | |
| | | select fn_alter_tab_fields(); |
| | | |
| | | select gid,depid,dirid from bd.b_borehole limit 10; |
| | | select gid,depid,dirid from bd.dlg_agnp limit 10; |
| | | select gid,depid,dirid from bd.dlg_25w_resa limit 10; |
| | | select gid,depid,dirid from bd.dlg_25w_boul limit 10; |
| | | select depid,dirid from bd.dlg_agnp group by depid,dirid; |
| | | select depid,dirid from bd.dlg_25w_resa group by depid,dirid; |
| | | select depid,dirid from bd.dlg_25w_boul group by depid,dirid; |
| | | select * from lf.sys_dict where tab='dlg_25w_boul'; |
| | | --------------------------------------------------------- |