In PHP, mysqli_release_savepoint() removes a named savepoint from the current transaction without rolling the transaction back.
It belongs to the transaction family with begin_transaction(), savepoint(), rollback(), and commit(). After release, that savepoint name is no longer a rollback target. The surrounding transaction stays open until you commit or roll back.
Syntax
Call mysqli_release_savepoint() with the values you need. Start with this line.
PHP
$ok = mysqli_release_savepoint($mysql, 'sp1');
Call
What it does
mysqli_release_savepoint($link, 'after_insert')
Drops the named savepoint if it exists in the open transaction.
$mysqli->release_savepoint('sp1')
Object-oriented form with the savepoint name.
mysqli_rollback($link, 0, 'sp1')
Contrast: rollback to a savepoint undoes work; release only removes the marker.
Call this only inside an open transaction after mysqli_savepoint(). Releasing does not undo SQL you already ran. Use rollback() with a name when you need to undo back to that marker.