MySQL Forums
Forum List  »  Newbie

Best way to develop\test SP's & Functions?
Posted by: Matthew Delphi
Date: February 01, 2023 06:38AM

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.



Options: ReplyQuote

Written By
Best way to develop\test SP's & Functions?
February 01, 2023 06:38AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.