SELECT C.*, (SELECT CC.AUTHORITY FROM SYS_CODE_CLASSIFY CC WHERE C.CODE_CATEGORY_CODE = CC.CODE_CATEGORY_CODE) AS AUTHORITY FROM SYS_CODE C WHERE C.CODE_CATEGORY_CODE = 'SYS_ATTACH_FILEPATH' AND C.CODE_VALUE = 'attachadd' AND C.CODE_STATE = '1' ;

SELECT C.*, (SELECT CC.AUTHORITY FROM SYS_CODE_CLASSIFY CC WHERE C.CODE_CATEGORY_CODE = CC.CODE_CATEGORY_CODE) AS AUTHORITY FROM SYS_CODE C WHERE C.CODE_CATEGORY_CODE = 'SYS_ATTACH_FILEPATH' AND C.CODE_VALUE = 'wxImgUpload' AND C.CODE_STATE = '1' ;

SELECT T.CONFIG_STAND_ID, T.STAND_EXPEND_NAME, T.RECEIPT_INFO, T.PARTB_INFO, T.RECEIPT_CODE, T.NO_RECEIPT, T.PAY_NAME, T.REMARK , T.CODE, GET_DICTIONARY_NAME(T.CODE, 'SMART_EXPEND_NAME') AS NAME FROM FIN_EXPEND_CONFIG_STAND T ;

select CODE_CATEGORY_CODE, CODE_CATEGORY_ID, CODE_CATEGORY_NAME, PARENT_ID, CASCADE_ID, REMARK, AUTHORITY, CLASSIFY_CODE, IS_LEAF, SORTID , GET_DICTIONARY_NAME(AUTHORITY, 'SYSTEM_AUTH_TYPE') AS AUTHORITY_NAME from sys_code_classify where 1 = 1 AND CODE_CATEGORY_CODE = 'weiXin';

SELECT * FROM SYS_CODE C WHERE C.CODE_CATEGORY_CODE = 'weiXin' AND C.CODE_STATE = '1' ORDER BY C.CODE_VALUE ;

以上sql数据库依次执行看下是否能查询

如报The user specified as a definer ('root'@'%') does not exist
执行以下代码

grant all privileges on *.* to root@'%' identified by '.';
flush privileges;