2
Every time I change a process in Mysql Workbench and try to write (Apply) and I get the following message (No changes Detected) there to get around the problem I delete and recreate the process.
That’s too boring someone knows how to solve?
Below is two images that shows that after changing the process it does not identify change and does not save.
Thank you.
1
Mysql displays this message MySql - No changes detected, one sees that the script has already been executed or nothing has been changed in Script.
What may have happened is you have clicked on Apply a view and then continue clicking.
Change your select and see that it changes.
And your DEFINER=root@%
Open a new tab with your previous scrip as follows and run.
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 ;
I’ve changed several times and I’ve already clicked on Apply several times and the process always goes back to the form with the content with which it was created the first time, do you know if there is a way to disable this identification if the trial has been changed or not? Like I don’t care if the trial was changed or not, if I clicked on the record and to record and ready as world.
I tried with root and also does not record.
Try changing through the script .
This way it works but loses the practicality that the tool offers, I believe that what is happening is a bug of Workbench itself. Anyway thanks so much for the help.
Browser other questions tagged mysql
You are not signed in. Login or sign up in order to post.
Post the code of how you tried to change the code.
– DH.
Post code not image.
– Marco Souza
I put two images, I think it’s easier to understand, there must be some option to disable this modified code identification, but I could not find.
– Mauricio Ferraz
The code is that of the image. a simple select and it does not identify the change.
– Mauricio Ferraz
What are you changing ??????????
– Marco Souza
@Marconciliosouza maybe you didn’t see the difference in the images in the second image I added a line, no matter how many lines I change or add it doesn’t record. That’s what I’m changing.
– Mauricio Ferraz