MySQL Conference
O’Reilly Media will be hosting the MySQL Conference in Santa Clara, California: April 12 - 15, 2010.
MySQueaL Resources
04 mar. 2010 - 10:45:30 am
315 hits past day
Search Site
Miscellany
special notices
Color Highlights
When you look at SQL statements and functions on the pages for some sections of our documentation for MySQL, you may notice that some are shown in a different color (light blue at the moment). What we've done is set up a log to keep track of which pages of our documentation readers view. From there, our script every few minutes determines the most popular statements and functions and changes the colors of the links to those pages.
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 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.
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 our 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.
MySQL SubQueries
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.
Stored Routines
MySQL stored routines are preset, stored batches of SQL statements to be called upon as needed.
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 we haven't categorized yet.