Examples of savepoints and transactions

Lars Nielsen <[email protected]> Sun, 21 Jan 2018 21:37:42 +0100
Newsgroups gmane.comp.db.mysql.general
Message-ID <[email protected]>
Hi,
I have a system that uses begin and commit transactions. It works like a dream! ;)
Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution for rolling back test data is to use savepoints and rollback. I think it is hard to find examples of this scenario. Are there some good guides or tutorials out there somewhere? Any suggestions are welcome.

Best regards 
Lars Nielsen

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql