我在
mysql中编写了一个存储过程来进行更新.当你在mysql命令行中执行它时(通过Mysql编辑器),这工作正常.
存储过程是:
CREATE DEFINER=`root`@`localhost` PROCEDURE `Deduction_Of_PL`(
IN P_EMPID VARCHAR(1000)
)
BEGIN
DECLARE PresentYearPL VARCHAR(1000);
set PresentYearPL=(select Present_Year_PL from leave_calculate_pl where employee_id=P_EMPID);
IF(PresentYearPL<=0) THEN
UPDATE leave_calculate_pl
SET Carrie_PL=Carrie_PL-1
where employee_id=P_EMPID;
ELSE
UPDATE leave_calculate_pl
SET Present_Year_PL=Present_Year_PL-1
where employee_id= P_EMPID;
END IF;
END $$
我在PHP中调用相同的存储过程,我也传递输入参数.
$LeaveTypeID_G=$this->getLeaveTypeId();
$query_G="CALL Deduction_Of_PL($LeaveTypeID_G)";
它给出了错误
Unknown column 'parameter_value' in 'field list' MySQL Error # :1054
请告诉我哪里出了问题,我该如何解决.