From c4e3ccb0b53486f025a7c35694efdd2267142149 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期一, 16 一月 2023 19:10:21 +0800 Subject: [PATCH] 1 --- data/update.sql | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/data/update.sql b/data/update.sql index af088e9..f0323ab 100644 --- a/data/update.sql +++ b/data/update.sql @@ -1,3 +1,6 @@ +select * from lf.sys_menu where position('http://' in url) > 0; +select url, replace(url, 'pipe.cppe.com', '{host}') from lf.sys_menu where position('http://' in url) > 0; +update lf.sys_menu set url = replace(url, 'pipe.cppe.com', '{host}') where position('http://' in url) > 0; ------------------------------------------------------ 鏇存柊鑿滃崟+鐢ㄦ埛 select * from lf.sys_menu where cn_name = '鏁版嵁搴撶洃鎺�'; -- update lf.sys_menu set url = 'http://pipe.cppe.com:8088/server/druid/index.html' where cn_name = '鏁版嵁搴撶洃鎺�'; -- Gitblit v1.9.3