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 = '数据库监控';