Miscellany
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 StatementsMySQL user and security statements can be used to add and remove users and to change their privileges in MySQL. |
Stored RoutinesMySQL stored routines are preset, stored batches of SQL statements to be called upon as needed. |
Database & Table Schema StatementsThis section includes SQL statements related to the creating and altering of databases and tables. (e.g., CREATE TABLE, ALTER TABLE, and DROP TABLE). |
Aggregate FunctionsMySQL 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 StatementsThis section of our documentation of MySQL explains SQL statements for administering of MySQL databases (e.g., REPAIR TABLE and SHOW PROCESSLIST). |
String FunctionsMySQL string functions can be used to change the value of columns containing strings of alphanumeric values. |
Data Manipulation StatementsThis section includes SQL statements related to the manipulation of the contents of tables (e.g., SELECT, INSERT, and UPDATE). |
Date & Time FunctionsMySQL date and time functions can be used to change the value of date and time columns. |
Transaction StatementsMySQL transaction statements can be used for executing a series of statements in MySQL, in batch. This includes being able to undo batches. |
Math FunctionsMySQL math functions can be used to change the value of columns containing numeric values. |
MySQL ReplicationMySQL 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 ControlMySQL 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 SubQueriesThis 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 & FunctionsThese statements and functions of MySQL are ones that we haven't categorized yet. |
Need Math Examples
Although we did well in math classes all through school, we have very little experience with the Math Functions of MySQL very little. As a result, we don't have very good examples for them. If you work in science or engineering and have some ideas for easy to understand examples that we can add, please tell us.
MySQL Replication
Whether you’re new to MySQL replication or have been using it for some time, you will find this new book useful. It will help you actually to understand MySQL replication so you can keep it running. It’s especially useful when replication stops and you can’t get it started again.
