MySQL Conference
O’Reilly Media will be hosting the MySQL Conference in Santa Clara, California: April 12 - 15, 2010.
MySQueaL Resources
04 mar. 2010 - 10:45:30 am
1296 hits past day
Search Site
Miscellany
special notices
Color Highlights
When you look at SQL statements and functions on the pages for some sections of our documentation for MySQL, you may notice that some are shown in a different color (light blue at the moment). What we've done is set up a log to keep track of which pages of our documentation readers view. From there, our script every few minutes determines the most popular statements and functions and changes the colors of the links to those pages.
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 Transaction Statements
MySQL transaction statements can be used for executing a series of statements in MySQL, in batch. This includes being able to undo batches.
Related SQL Statements
Below are MySQL statements related to the SQL topic selected.
BEGIN
Use this MySQL statement to start a transaction.
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.
RELEASE SAVEPOINT
This MySQL statement instructs the server to release a savepoint named earlier with the SAVEPOINT statement for the current transaction.
ROLLBACK
Use this MySQL statement with transactional tables to reverse transactions that have not yet been committed.
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.
SAVEPOINT
Use this MySQL statement to identify a point in a transaction to which SQL statements may potentially be undone later.
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.
START TRANSACTION
Use this MySQL statement to start a transaction.