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.

SQL Statements

Data Manipulation

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

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

User & Security Statements

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

Table & Server Admin

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

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.

Transactions

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.

Other Statements

These functions of MySQL are ones that we haven't categorized yet, that are very different from other functions.

Daemons & Clients

MySQL Clients

These are clients that users may use to access a MySQL server and its databases.

MySQL Daemons

These are daemons which run on MySQL, they are MySQL and related daemons.

Functions

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.

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.

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 Functions

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.

Utilities

Back-Up Utilities

This section provides documentation on backup-up utilities (e.g., mysqldump).

Server Utilities

You can use these utilities to administer the MySQL server and data. Some interact with the server and others manipulate directly the data files for MySQL.

Table Utilities

These utilities are related to administering tables and data in MySQL. Some interact with the server and others manipulate directly the data files for MySQL.