当我的数据库中已经存在prcCompareWithSameItem这个存储过程时,下面这样执行不了?
提示说错误码: 1304
PROCEDURE prcCompareWithSameItem already exists
DELIMITER $$DROP PROCEDURE IF EXISTS `compare`.`prcCompareWithSameItem`$$CREATE DEFINER=`root`@`localhost` PROCEDURE `prcCompareWithSameItem`(in item_id bigint)
begin
declare sSql varchar(3000);
set sSql=concat("select * from ccc");
set @sQuery=sSql;
prepare stmt from @sQuery;
execute stmt;
end$$DELIMITER ;
提示说错误码: 1304
PROCEDURE prcCompareWithSameItem already exists
DELIMITER $$DROP PROCEDURE IF EXISTS `compare`.`prcCompareWithSameItem`$$CREATE DEFINER=`root`@`localhost` PROCEDURE `prcCompareWithSameItem`(in item_id bigint)
begin
declare sSql varchar(3000);
set sSql=concat("select * from ccc");
set @sQuery=sSql;
prepare stmt from @sQuery;
execute stmt;
end$$DELIMITER ;
use `compare`;DELIMITER $$DROP PROCEDURE IF EXISTS `compare`.`prcCompareWithSameItem`$$CREATE DEFINER=`root`@`localhost` PROCEDURE `compare`.`prcCompareWithSameItem`(in item_id bigint)
begin
declare sSql varchar(3000);
set sSql=concat("select * from ccc");
set @sQuery=sSql;
prepare stmt from @sQuery;
execute stmt;
end$$DELIMITER ;
或者给你的CREATE DEFINER=`root`@`localhost` PROCEDURE `compare`.`prcCompareWithSameItem`(in item_id bigint)加上数据库名。
DELIMITER $$
DROP PROCEDURE IF EXISTS `compare`.`prcCompareWithSameItem`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `prcCompareWithSameItem`(in item_id bigint)
begin
declare sSql varchar(3000);
set sSql=concat("select * from ccc");
set @sQuery=sSql;
prepare stmt from @sQuery;
execute stmt;
end$$ DELIMITER ;