Mysql存储过程报1064错误,提示语法错误?
发布网友
发布时间：2022-04-08 10:47
共1个回答
热心网友
时间：2022-04-08 12:16
DROP PROCEDURE IF EXISTS count_role;
CREATE PROCEDURE `count_role`(in p_role_name varchar(20),out count_total int,out exe_date date)
BEGIN
select count(*) into count_total from t_role where role_name like '%' || p_role_name || '%';
select sysdate into exe_date from al;
END;
//
DELIMITER ;
