CREATE DEFINER=`abc`@`localhost` PROCEDURE `site_data_conversion`(in $src_site_id int, in $t_site_id int, out $return_code int, out $result_code int)
BEGIN
declare _err int default 0;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION,SQLWARNING set _err=1;
START TRANSACTION;
CREATE TEMPORARY TABLE `abc`.`tmp_table` select * from items where site_id=$src_site_id;
update `abc`.`tmp_table` set site_id=$t_site_id where site_id=$src_site_id;
show warnings;
insert into items select * from `abc`.`tmp_table`;
show warnings;
DROP TEMPORARY TABLE IF EXISTS `abc`.`tmp_table`;
if _err = 1 then
ROLLBACK;
set $return_code=0;
set $result_code=0;
else
COMMIT;
set $return_code=1;
set $result_code=ROW_COUNT();
end if;
END
執行就提示 Table 'abc.tmp_table' doesn't exist
uj5u.com熱心網友回復：
洗掉一部分代碼，再試， 看看具體是哪一句報的錯。uj5u.com熱心網友回復：
放到控制臺執行正常，在存盤程序里就提示 Table 'abc.tmp_table' doesn't exist，刪了多余代碼也沒用。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/115323.html
標籤：MySQL