savepoint commit rollback in mysql [duplicate]

Question

how can we use commit, rollback, and savepoint in MySQL ?

Answer 1

savepoint commit rollback in MySQL. It is a very important command to modify the table.

COMMIT command is used to forever save any transaction into the database.

This command restores the database to the last committed state. It is also used with the SAVEPOINT command to skip to a savepoint in an ongoing transaction.

SAVEPOINT command is used to temporarily save a transaction so that you can rollback to that point whenever required.

commit command's syntax,

COMMIT;

rollback command's syntax,

ROLLBACK TO savepoint_name;

savepoint command's syntax,

SAVEPOINT savepoint_name;