Every time I change a procedure in the MySql Workbench and I try to write and I get the following message (No changes detected) there to work around the problem I delete and re-create the procedure.
This is very annoying does anyone know how to solve?
Below are two images that shows that after changing the procedure it does not identify change and does not write.
Thank you.
Mysql displays this message MySql - No changes detected , once the script has already been run or nothing has been changed in the script.
What may have happened is that you click Apply on a view and then continue clicking.
Change your select and see that it will change.
And its DEFINER= root @ %
Open a new tab with your procedure scrip as follows and execute.
USE 'seu banco';
DROP procedure IF EXISTS 'procedureTeste';
DELIMITER $$
USE 'seu banco'$$
CREATE DEFINER='root'@'%' PROCEDURE 'procedureTeste'()
BEGIN
select 'teste';
select 'teste2';
select 'teste3';
select 'teste4';
-- altera o que for preciso e execulta.
END$$
DELIMITER ;