MySQL Documentation

This section is our own documentation of MySQL database software. We're still putting it together, so some introductory text is missing. But when you get to documentation pages, those are in pretty good shape. Still, if you see any mistakes or have suggestions for improving the text or examples, please let us know. Once this is set up, our hope is to add more examples of using the individual MySQL statements and functions.

User & Security Statements

MySQL user and security statements can be used to add and remove users and to change their privileges in MySQL.

Stored Routines

MySQL stored routines are preset, stored batches of SQL statements to be called upon as needed.

Database & Table Schema Statements

This section includes SQL statements related to the creating and altering of databases and tables. (e.g., CREATE TABLE, ALTER TABLE, and DROP TABLE).

Aggregate Functions

MySQL aggregate functions are used to return totals, averages, and other statistical information from MySQL. Data is grouped together based on specified columns.

Table & Server Administration Statements

This section of our documentation of MySQL explains SQL statements for administering of MySQL databases (e.g., REPAIR TABLE and SHOW PROCESSLIST).

String Functions

MySQL string functions can be used to change the value of columns containing strings of alphanumeric values.

Data Manipulation Statements

This section includes SQL statements related to the manipulation of the contents of tables (e.g., SELECT, INSERT, and UPDATE).

Date & Time Functions

MySQL date and time functions can be used to change the value of date and time columns.

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.

Math Functions

MySQL math functions can be used to change the value of columns containing numeric values.

MySQL Replication

MySQL replication involves maintaining a separate server which is a continuous copy of a primary, master MySQL server. These statements and functions are related to those activities.

Flow Control

MySQL flow control functions can be used to query given columns and return results for a field based on the results of the column query.

MySQL Sub-Queries

This section tries to explain MySQL subqueries. There are no subquery statements or functions per se, so this section is less in a dictionary style than the other sections.

Other Statements & Functions

These statements and functions of MySQL are ones that we haven't categorized yet.