是否有MySQL版本的“创建或替换过程”?我似乎无法执行此操作或脚本删除过程,如果在重新编译之前存在,而不会收到存储过程存在的错误消息.
DELIMITER $$
-- would love to be able to drop procedure if exists db.sp_tmp_90days;
-- or use "create or replace"
create procedure db.sp_tmp_90days()
BEGIN
drop table db.tmp_90days;
create table db.tmp_90days (
user_name varchar(128),
first_name varchar(50),
last_name varchar(50),
system varchar(10),
last_login datetime
);
alter table db.tmp_90days add index idx_user_name(user_name);
alter table db.tmp_90days add index idx_system(system);
alter table db.tmp_90days add index idx_last_login(last_login);
insert into db.tmp_90days (user_name, first_name, last_name, system, last_login)
SELECT
[...]
END $$
解决方法:
这是删除它的语法(如果存在)
DROP PROCEDURE IF EXISTS db.sp_tmp_90days;
标签:mysql,stored-procedures
来源: https://codeday.me/bug/20190805/1588227.html