Is there a way to test your MySQL trigger? like a debug mode for example in Visual Studio where you can keep track the output per line? Coz it sucks whenever I implement one the production. Sometimes it mess up our DB Trans.


  • 2
    Clone the db
    Apply trigger to new db
    Run a bunch of queries
    Implement to prod
  • 1
    @C0D4 This is shat Im doing since then. But thanks for the input sir
  • 1
    @2ez4Me0wthy unfortunately Dbs are still in the dark ages when it comes to testing things like triggers.

    I just clone, and delete after testing.

    Unless someone else knows of a better way.
Add Comment