我写了一个存储过程。它执行正常,但是当我调用该过程时,它显示错误:
错误代码:1327 未声明的变量:
第三
请看我下面的流程:
DELIMITER $$
USE `db_test`$$
DROP PROCEDURE IF EXISTS `test_proc`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `test_proc`(IN newsInfoTable VARCHAR(100))
BEGIN
SET @sql_stam = CONCAT('SELECT news INTO ', @news,' FROM ',newsInfoTable,' WHERE ',CURDATE(),'=?;');
PREPARE s1 FROM @sql_stam;
SET @where_param = DATE_FORMAT(date_time,'%Y-%m-%d');
EXECUTE s1 USING @where_param;
SELECT @news;
END$$
DELIMITER ;
调用参数:
USE db_test;
CALL test_proc('tbl_morning_news');
将您的代码更改为:
DELIMITER $$
USE `db_test`$$
DROP PROCEDURE IF EXISTS `test_proc`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `test_proc`(IN newsInfoTable VARCHAR(100))
BEGIN
SET @sql_stam = CONCAT( 'SELECT news INTO @news FROM ',newsInfoTable
,' WHERE DATE(`date_time`) = CURDATE()' );
PREPARE s1 FROM @sql_stam;
SELECT @news;
END$$
DELIMITER ;
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)