Other SQL Statements

These functions of MySQL are ones that we haven't categorized yet, that are very different from other functions, or have don't have similarities to one specific category. 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.

LOAD INDEX INTO CACHE

Use this MySQL statement to preload a table's index into a given key cache for a MyISAM table.

USE

This MySQL statement sets the default database MySQL is to use for the current session.

XA

This MySQL statement is used for XA distributed transactions.