http 换成 https 

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'

　　

posted @ 2019-03-09 23:04  GL_BKY  阅读(343)  评论(0)  编辑  收藏  举报