Best way to develop\test SP's & Functions?

[Matthew Delphi]

Good Day

As a long time ad hoc developer of MSSQL, my approach to creating and developing SP's and functions was to develop the code as a query, with a set of variables from the top, then transfer into a procedure when I was happy.

This approach allowed me to step through, get interim results, stop it in places etc.

The issue I have discovered with MYSQL, is that there seems to be fair chunks of code that only works within a SP, such as IF, THEN, ELSE.

Therefore, how do MYSQL people develop SP's and functions. Is there a trick I'm missing?

I'm currently using the dbForge Studio, but have had a brief play with workbench.

Thanks

Matthew