<!-- 取所用带信息的终极栏目 高级搜索的栏目多选框使用 -->
<select id="getMenuCatVOList" resultClass="MenucatVO" parameterClass="MenucatVO" cacheModel="FSmenu-cache">
<![CDATA[
SELECT menuid,
menuname,
coltype,
siteroot,
ltrim(MAX(SYS_CONNECT_BY_PATH(menuname,'->')), '->') menunames
FROM tbl_menu
WHERE isendmenu = 'Y'
AND siteroot = #siteroot#
AND coltype=#coltype#
START WITHpid = 0
用Mysql怎样实现Oracle中的SYS_CONNECT_BY_PATH函数和START WITH ...CONNECT BY PRIOR方法
最新推荐文章于 2022-09-02 17:30:52 发布