过程中的MySQL WHERE条件被忽略 [英] MySQL WHERE-condition in procedure ignored

问题描述

我正在尝试创建一个带有参数的过程.但是，当我在WHERE条件下使用它们时，就像从未有过.他们只是被忽略.

I am trying to make a procedure with arguments. But when I use them in a WHERE condition it is like there were never there. They are simply ignored.

DELIMITER //

DROP PROCEDURE IF EXISTS p //

CREATE PROCEDURE p (IN player TEXT, OUT num INT)
BEGIN
  SELECT COUNT(*) INTO num FROM `sg_playerstats` WHERE `player` = player; 
END

//

DELIMITER ;

正确填充数字，但是无论我输入播放器多少，结果始终为66.(该表有66行！)

Num gets filled correctly, but whatever I put in player, the result is ALWAYS 66. (The table has 66 rows!)

我在做什么错??

推荐答案

重命名您的参数，

CREATE PROCEDURE p (IN _player TEXT, OUT num INT)
BEGIN
  SELECT COUNT(*) INTO num FROM `sg_playerstats` WHERE `player` = _player; 
END

之所以这么做，是因为它碰巧发生了名称冲突.

the reason why you are getting that is because it happens to have name collision.

这篇关于过程中的MySQL WHERE条件被忽略的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！