UPDATE ????SYS_MENU M SET ????M.href = ????( ???SELECT ????????CASE WHEN ?substr(N.href, 0, 5) = ‘http:‘ THEN ?‘https:‘||substr(N.href, 6) ?????????ELSE N.href END href ????FROM ????????SYS_MENU N ???WHERE ????????M.ID = N.ID ???) ????WHERE ????????M.ID = ‘20a17234cd1f439b87cef0361653b66b‘ ???????????
http 换成 https
原文地址：https://www.cnblogs.com/guoziyi/p/10503612.html