Transaction Statements

This section provides information on SQL statements available in MySQL for transactions. Transactions are a set of SQL statements that the server has to execute as a unit; either all succeed or all fail. If the server detects that all have succeeded, it commits the transaction; if any statement fails, the server rolls back the previous statements. Transactions are supported by the InnoDB, BDB, and NDB Cluster storage engines, as well as some new storage engines for MySQL that are under development. Statements that manipulate transactions are ignored if executed against a storage engine that doesn't support transactions, notably MyISAM.
BEGIN
 Use this MySQL statement to start a transaction.
ROLLBACK TO SAVEPOINT
 This MySQL statement instructs the server to reverse SQL statements for the current transaction back to a point marked in the transaction by the SAVEPOINT statement.
COMMIT
 Use this MySQL statement to commit transactions, which are SQL statements that have changed data and that have been entered into MySQL but not yet saved.
SAVEPOINT
 Use this MySQL statement to identify a point in a transaction to which SQL statements may potentially be undone later.
RELEASE SAVEPOINT
 This MySQL statement instructs the server to release a savepoint named earlier with the SAVEPOINT statement for the current transaction.
SET TRANSACTION
 Use this MySQL statement to set an isolation level for the current transaction, for a transaction that's about to be started, or globally.
ROLLBACK
 Use this MySQL statement with transactional tables to reverse transactions that have not yet been committed.
START TRANSACTION
 Use this MySQL statement to start a transaction.

Need Math Examples

Although we did well in math classes all through school, we have very little experience with the Math Functions of MySQL very little. As a result, we don't have very good examples for them. If you work in science or engineering and have some ideas for easy to understand examples that we can add, please tell us.

MySQL Replication

Whether you’re new to MySQL replication or have been using it for some time, you will find this new book useful. It will help you actually to understand MySQL replication so you can keep it running. It’s especially useful when replication stops and you can’t get it started again.