If your MySQL database interfaces with applications or is used to generate reports then chances are good that it contains some massive stored procedures, just brimming with intensive logic and calculation code. In that case, you had better set up some type of unit testing framework so that you can verify that your SQL code is doing what it should. This article will introduce MyTAP, a unit-test suite based on the Test Anything Protocol (TAP). It’s the brainchild of David E. Wheeler, who based his creation on the more general database testing tool called pgTAP.

Mas:

http://www.databasejournal.com/features/mysql/testing-your-mysql-stored-procedures-with-mytap.html