Other Statements & Functions

These statements and functions of MySQL are ones that we haven't categorized yet. Eventually, we'll move them to other sections or rename this section to something that sums up the statements and functions that we can't put elsewhere.
HELP
This MySQL statement can be used to access built-in documentation.
XA
This MySQL statement is used for XA distributed transactions.
USE
This MySQL statement sets the default database MySQL is to use for the current session.
LOAD INDEX INTO CACHE
Use this MySQL statement to preload a table's index into a given key cache for a MyISAM table.

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.