Best tool for unit testing in MySQL

Question

I've been doing a lot of sproc programming in MySQL lately.
And I must say that I like it. A lot.

However debugging these babies sucks.
Anyone know of any tools that can put some happiness in My MySQL debugging?

Answer 1

http://www.mydebugger.com/

There is a limited free version, but the full version is not too expensive either.

Here is screenshot:

Answer 2

Have you considered using

https://github.com/hepabolu/mytap

For unit testing the db you should have something native that works in MySQL.

Answer 3

For Unit Testing, you can try this: http://stk.wikidot.com/stk-unit

Answer 4

If you pefer writing your test in C++ you can use googletest:

https://code.google.com/p/googletest/

You can find a good overview on the mySQL documentation webside:

http://dev.mysql.com/doc/mysqltest/2.0/en/unit-tests-google-test.html