SAVEPOINT is a point in a transaction, up till which all changes have been saved permanently'
EXAMPLE:
mysql>
mysql> CREATE TABLE Books -> ( -> BookID SMALLINT NOT NULL PRIMARY KEY, BookTitle VARCHAR(60) NOT NULL, CopyrightYEAR NOT NULL)
> ENGINE=INNODB;
mysql> START TRNSACTION;
mysql> INSEKI INTO Books VALUES (103,'Opera', 1966);
mysql> INSERT INTO Books VALUES (104,'Sql Sewer', 1932);