存储过程调用时参数个数和实际参数个数不匹配
DROP PROCEDURE IF EXISTS `deleteById`;
delimiter $$
create procedure deleteById(in idd int)
begin
delete from person where id=idd ;
end $$
delimiter;
调用时:
call deleteById(6,@k);
select @k;
会报错
1318 - Incorrect number of arguments for PROCEDURE studendb.deleteById; expected 1, got 2
改成call deleteById(6);即可