| | |
| | | select * from lf.sys_operate order by id desc limit 20; |
| | | select * from lf.sys_report; |
| | | |
| | | select fn_rec_query(depid, 'dep') "m1" , count(sizes) "sizes" |
| | | select fn_rec_query(depid, 'dep') "m1", count(sizes) "sizes" |
| | | from lf.sys_meta |
| | | group by depid |
| | | order by depid; |
| | | |
| | | select name "m1", count(*) "count" |
| | | from lf.sys_serve_log |
| | | group by name |
| | | order by name; |
| | | select fn_rec_query(depid, 'dep') "m1", count(sizes) "sizes" |
| | | from lf.sys_meta |
| | | group by depid |
| | | order by depid; |
| | | |
| | | select modular1 "m1", modular2 "m2", count(*) "count" |
| | | from lf.sys_operate |
| | |
| | | |
| | | select * from lf.sys_operate where modular2 = '' or modular2 = '2' or modular2 is null; |
| | | delete from lf.sys_operate where modular2 = '' or modular2 = '2' or modular2 is null; |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |