MySQL - Statements Reference



Here is the list of all important MySQL statements. Each statement has been explained along with suitable example.

Data Definition Statements

Data Manipulation Statements

Transactional and Locking Statements

Prepared Statements

Compound Statements

Variables in Stored Programs

MySQL Flow Control Statements

  • MySQL CASE Statement − This statement is used to test a value for equality against a list of values/conditions.

  • MySQL IF Statement − This executes a set of statements as long as the given condition is satisfied.

  • MySQL ITERATE Statement − This statement is used to restart the LOOP, REPEAT or, WHILE statements.

  • MySQL LEAVE Statement − This statement is used to exit the LOOP, REPEAT, WHILE statements or, BEGIN…END statements.

  • MySQL LOOP Statement − This statement is used to execute a single or set of statements repeatedly.

  • MySQL REPEAT Statement − This statement is used to repeat the given set of statements (or statement) until the value of the given search condition is TRUE.

  • MySQL RETURN Statement − This statement is used to end the stored functions.

  • MySQL WHILE Statement − This statement is used to execute a single or set of statements repeatedly as long as the specified condition is TRUE.

MySQL Cursors Statements

MySQL Condition Handling Statements

MySQL Account Management Statements

MySQL Resource Group Management Statements

MySQL Table Maintenance Statements

MySQL Miscellaneous Statements

MySQL SHOW Statements

MySQL Other Administrative Statements

MySQL Utility Statements

  • MySQL DESCRIBE Statement − You can get the information about the table structure using this statement.

  • MySQL EXPLAIN Statement − Using this statement you can get the execution plan of the specified query.

  • MySQL HELP Statement − This statement is used to retrieve the information from the MySQL official documentation about the specified string.

  • MySQL USE Statement − You can select/use an existing database using this statement.

Advertisements