From d539637587e961712451ea8c42e043a2a0ad5971 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期六, 07 一月 2023 13:17:54 +0800 Subject: [PATCH] 1.7 --- data/ts.sql | 12 ++++++++++++ 1 files changed, 12 insertions(+), 0 deletions(-) diff --git a/data/ts.sql b/data/ts.sql index 52e802a..9ed9b3f 100644 --- a/data/ts.sql +++ b/data/ts.sql @@ -162,6 +162,18 @@ update lf.sys_meta_new set depid=1,type='file',path='2\'||name,sizes=1; +with rs as (select id from lf.sys_dir where name='瑗挎皵涓滆緭鍥涚嚎澶╃劧姘旂閬撳伐绋嬶紙鍚愰瞾鐣�-涓崼锛夛紙00116BT02锛�') +select fn_rec_query(a.dirid,'dir'),a.* from lf.sys_meta_new a where dirid = ANY(fn_rec_array((select id from rs), 'dir')); + + + + + + + + + + -- Gitblit v1.9.3