MySQL Documentation

This section is my own personal documentation of MySQL database software. I'm 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 me know. Once this is set up, my 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.

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).

Table & Server Administration Statements

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

Data Manipulation Statements

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

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.

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.

Stored Routines

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

SubQueries

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

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.

String Functions

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

Date & Time Functions

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

Math Functions

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

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.

Other Statements & Functions

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