MySQL Stored Procedure Compiles Without Error (I want the error to occur)
When you right click on stored procedures, you hit create stroed procedures.


this should show spelling errors like INsRT and systax erors

But logic errors it will not find.

So start using error handling and user defined variables to debug it properly.

But you can test all queries in a normal Query tab this would also check for syntax errors