mysql存储过程的参数名不要跟字段名一样_MySQL

[sql]DELIMITER $$ USE `b10k`$$ DROP PROCEDURE IF EXISTS `sp_delete_species`$$ CREATE DEFINER=`luth`@`%` PROCEDURE `sp_delete_species`( IN species_id INT, /*物种ID*/ OUT out_rows INT /*受影响行数*/ ) BEGIN DELETE FROM `sample` WHERE `species_ID` = species_id ; DELETE FROM `filepath` WHERE `species_ID` = species_id ; DELETE FROM `species` WHERE `species_ID` = species_id ; SET out_rows = ROW_COUNT(); END$$ DELIMITER ;