MySQL存储过程忽略DELETE语句 - MySQL stored procedure ignores DELETE statement

MySQL stored procedure ignores DELETE statement

本文关键字：DELETE 语句存储过程 MySQL | 更新日期: 2023-09-27

我有这个从PHP脚本调用的存储过程。它有几个select语句和一个delete语句。除了没有执行DELETE查询之外，一切都很好。它被忽略了!!请帮助。由于

CREATE PROCEDURE `proc_name`(IN id INT, IN type CHAR(50))
DETERMINISTIC
COMMENT 'procedure'
BEGIN 
DECLARE LEGACY_EN_ID INT;
SET IN_ID = id;
SELECT  IF(e.legacy_id > 0, e.legacy_id, 0) INTO LEGACY_EN_ID FROM tablename e WHERE e.id = IN_ID LIMIT 1;
/* Delete record if it exists */
        DELETE
        FROM tablename
        WHERE entityID = LEGACY_EN_ID;

检查执行存储过程的用户是否有权限执行该操作。