qq_34652478的博客

好久没有写博客了，今天碰到一个问题。单独查询rel_role_res表很快，运行select sys_role.* from sys_role where FIND_IN_SET(ROLE_ID,queryRelationRoles(94))很快，0.2s把结果运行select distinct(RES_ID) from rel_role_res where ROLE_ID in (select distinct(sys_role.ROLE_ID) from sys_role whe

DELIMITER $$CREATE PROCEDURE `delvalid`(in valid char(1))BEGIN DECLARE pos int; DECLARE sqlStr varchar(500); DECLARE tabStr varchar(500); DECLARE sTabStr varchar(128); SET...