From 35a5eec0d176b550fb0d7c5a0a5421b66f3b26c4 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期六, 11 二月 2023 11:36:42 +0800 Subject: [PATCH] 1 --- data/ts.sql | 14 +++++--------- 1 files changed, 5 insertions(+), 9 deletions(-) diff --git a/data/ts.sql b/data/ts.sql index 2935359..1a6c9cc 100644 --- a/data/ts.sql +++ b/data/ts.sql @@ -131,15 +131,15 @@ 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 @@ -148,10 +148,6 @@ 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; - - - - -- Gitblit v1.9.3