call select_employees(); doesn't work anymore
Good morning. I executed the code written in this video the first time and it worked. Since then, if I try to call the procedure again, it gives me an error saying that that procedure doesn't exist. I tried to execute again the previous code from the beginning, but after "drop procedure if exists select_employees;", if I try to execute the following code
delimiter $$
create procedure select_employees()
begin
select * from employees limit 1000;
end$$
delimiter ;
it executes the "drop procedure if exists select_employees;" again instead. So when I call the procedure it says that the procedure doesn't exist. Why the code between "delimiter $$" and "delimiter ;" doesn't work anymore? Thank you
Hi Alessandro!
Thanks for reaching out.
You can simply remove the code which drops the procedure. You have to create it and then you can call this procedure. You can check it in the Stored Procedures tab.
Hope this helps.
Best,
Tsvetelin
Good morning. It doesn't work even in that way. If I delete the previous code, it tries to execute the subsequent code. If I delete all the code except for the one that doesn't work, nothing happens.