盒子论坛 v2.1

SELECT
    MB.MENU_ID,
    min( Mr.PARENT_MENU_ID ),
    max(cast(ifnull ( mr.order_seq,- 1 ) as decimal(12))),
    MB.FUNCTION_ID,
    MB.MENU_NAME,
    MB.CHILD_MENU_FLAG,
    HF.FUNCTION_CODE,
    HF.VERSION_NUMBER,
    HF.FUNCTION_PATH,
    HF.FUNCTION_TYPE,
    min( HF.ATTRIBUTE1 ) a,
    min( MB.ATTRIBUTE1 ) b,
    MB.ATTRIBUTE2,
    MB.WINDOW_TYPE,
    hf.parameters
  FROM
    hfwk_menus_relation mr,
    HFWK_MENUS mb,
    hfwk_functions hf
  WHERE
    mb.MENU_ID = mr.child_menu_id
    AND hf.FUNCTION_ID = mb.function_id
    AND ifnull( mb.start_date, SYSDATE() + 1 ) <= SYSDATE() AND ifnull( mb.end_date, SYSDATE() + 1 ) >= SYSDATE()
    AND mb.function_id = hf.FUNCTION_ID
    AND mb.menu_type = 'WINFORM'
    AND hf.ENABLED_FLAG = 'Y'
    AND mr.menu_group_id in (" + str + @")
    /*递归查询*/



  /*  START WITH mr.parent_menu_id IN ( '10' ) CONNECT BY PRIOR mr.child_menu_id = mr.parent_menu_id */
  GROUP BY
    MB.MENU_ID,
    MB.MENU_SEQUENCE,
    MB.FUNCTION_ID,
    MB.MENU_NAME,
    MB.CHILD_MENU_FLAG,
    HF.FUNCTION_CODE,
    HF.VERSION_NUMBER,
    HF.FUNCTION_PATH,
    HF.FUNCTION_TYPE,
    MB.ATTRIBUTE2,
    hf.parameters,
    MB.WINDOW_TYPE
  ORDER BY
    min( Mr.PARENT_MENU_ID ),
    max(cast(ifnull ( mr.order_seq,- 1 ) as decimal(12)))

注解掉的这段话要改写成MYSQL哪位会帮我改一下谢谢
  START WITH mr.parent_menu_id IN in (" + str + @") CONNECT BY PRIOR mr.child_menu_id = mr.parent_menu_id
----------------------------------------------
-

作者：

bahamut8348 (leonna)	★☆☆☆☆	-
	普通会员

2021/3/8 15:36:24

1楼：

语句太长不想看，自己去查group_concat和find_in_set两个函数，这两个函数搭配可以完美模拟connect by子句
----------------------------------------------
--

信息

登陆以后才能回复