一个mysql 5.x用navicat建立一个存储过程
CREATE DEFINER=`root`@`%` PROCEDURE `myproc`(in `project` varchar(200))
BEGIN
DELETE FROM AList WHERE ProjectName= `project` ;
select * from AList WHERE ProjectName= `project` ;
END
通过帆软报表调用存储过程执行,
执行成功,但数据未删除,经过测试,发现将输入参数`project` 去掉`',变成
CREATE DEFINER=`root`@`%` PROCEDURE `myproc`(in project varchar(200))
BEGIN
DELETE FROM AList WHERE ProjectName= project ;
select * from AList WHERE ProjectName= project ;
END
帆软报表调用成功