Syntax:
SAVEPOINT identifier
ROLLBACK [WORK] TO SAVEPOINT identifier
RELEASE SAVEPOINT identifier

InnoDB supports the SQL statements SAVEPOINT and ROLLBACK TO SAVEPOINT.
Starting from MySQL 5.0.3, RELEASE SAVEPOINT and the optional WORK
keyword for ROLLBACK are supported as well.

URL: http://dev.mysql.com/doc/refman/5.0/en/savepoints.html

