I am running procedure , but my web application formats this procedure and runs it on mysql . The problem is that when the procedure is executed, it stays in only one line (without breaking lines). For example:
DELIMITER // CREATE PROCEDURE executar_procedure () BEGIN /*Meu código aqui!*/ END// DELIMITER ;
So, when running in mysql everything is in only one row, DELIMITER recognizes all the code after // as if it were still part of the delimiter, ie the delimiter does not only take the two bars to indicate that the procedure is starting here, but all the content that is on the line, and thus, I can not execute the procedure.
I've tried to use \ n after DELIMITER // but I did not succeed.
Thank you all for trying to help!