SELECT
a.resourceID AS resourceID,
b.menuName AS selfName,
a.selfType AS selfType,
b.menuID AS tempID,
(
SELECT COUNT(*) AS number
FROM sys_role_resource
WHERE selfType = 'SYS_MENU' AND parentType = 'SYS_MENU'
AND parentID = tempID
) AS menuNum,
(
SELECT COUNT(*) AS number
FROM sys_role_resource
WHERE selfType = 'SYS_ELEMENTS' AND parentType = 'SYS_MENU'
AND parentID = tempID
) AS elementNum
FROM
sys_role_resource a INNER JOIN sys_role_menu b ON a.selfID = b.menuID
AND a.selfType = 'SYS_MENU'
AND a.parentType = 'SYS_APP'
AND b.isDelete = 1
WHERE
a.parentID = 7
SQL语句如上
现在有两个MySQL数据库(5.6, 5.7),表结构和数据相同,但是为什么能在5.6的数据库中执行,但是在5.7的数据库里就执行不了。
是因为数据库版本的问题吗?还是因为5.7的数据库是我刚搭建的,没进行什么相关配置啊?
求大神指导啊 T_T
是怎么解决的???