Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Home > Database > Mysql Tutorial > body text

oracle start with 改成mysql

WBOY

Release： 2016-06-06 09:45:06

Original

3362 people have browsed it

mysqlstart withoracle

SELECT t.*
FROM (SELECT DISTINCT (sm.menu_id),
sm.up_menu_id,
sm.menu_name,
sm.menu_method,
sm.leaf,
sm.VALID_FLAG
FROM sys_menu sm,
sys_role_menu srm,
sys_role sr,
sys_user_role sur
WHERE sm.menu_id = srm.menu_id
AND srm.role_id = sr.role_id
AND sr.role_id = sur.role_id
AND sur.user_id = 3) t
START WITH t.up_menu_id = 999999
connect BY prior menu_id = t.up_menu_id

0 999999 系统管理
11 0 菜单管理
27 11 添加菜单操作
29 11 转到修改菜单页面
30 11 修改菜单操作
74 11 删除菜单操作
12 0 角色管理
24 12 转到修改角色
79 12 转到添加角色
80 12 添加角色操作
81 12 修改角色操作
107 12 删除角色操作
13 0 角色对应菜单
14 13 转到角色菜单绑定
25 13 角色绑定菜单操作
102 13 角色菜单删除操作

这是oracle 效果
现在要换成myslq 怎么写？

Related labels：

mysql start with oracle

source：php.cn

Previous article：bind + mysql +bind-dlz实现类DNS功能 Next article：mysql 数据库无法导入表

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn