How do I debug a stored procedure in mysql?

How do I debug a SQL stored procedure?

To debug a function, open the procedure calling that function and insert a breakpoint for the function you want to debug. Then, start debugging. Step through the code using the F11 key or Step Into, or press CTRL+F5 to move directly to the breakpoint. Press F11 or click Step Into to get inside the stored function.

Can we debug stored procedure?

To debugging SP, go to database->Programmability->Stored Procedures-> right click the procedure you want to debug->select Debug Procedure.

How do I start MySQL in debug mode?

If you have some very specific problem, you can always try to debug MySQL. To do this you must configure MySQL with the option --with-debug . You can check whether or not MySQL was compiled with debugging by doing: mysqld --help . If the --debug flag is listed with the options then you have debugging enabled.

How do I log a stored procedure in MySQL?

declare myvar INT default 0; SET myvar = 5; insert into tmptable select concat('myvar is ', myvar); You could put the above in a stored procedure, so all you would have to write is this: CALL log(concat('the value is', myvar));