From 7d824c1e0b6fdd5ddb5d2cd783839895c416c75a Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期三, 19 四月 2023 09:40:28 +0800 Subject: [PATCH] 1 --- data/db_cx.sql | 3 +-- 1 files changed, 1 insertions(+), 2 deletions(-) diff --git a/data/db_cx.sql b/data/db_cx.sql index 13e914b..806583d 100644 --- a/data/db_cx.sql +++ b/data/db_cx.sql @@ -40,8 +40,7 @@ select sizes,ceil(sizes) from lf.sys_meta order by id desc limit 100 select * from lf.sys_publish order by id desc; select * from lf.sys_meta where type in ('tif', 'tiff', 'img', 'png', 'jpg') order by type - - +select fn_get_fullname(a.depcode, 1) depName, fn_get_fullname(a.dircode, 2) dirName, a.* from lf.sys_meta a order by id desc limit 10; -- Gitblit v1.9.3