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
1647 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.
Other MySQL Statements & Functions
These statements and functions of MySQL are ones that we haven't categorized yet.
Related SQL Statements
Below are MySQL statements related to the SQL topic selected.
HELP
This MySQL statement can be used to access built-in documentation.
USE
This MySQL statement sets the default database MySQL is to use for the current session.
XA
This MySQL statement is used for XA distributed transactions.
LOAD INDEX INTO CACHE
Use this MySQL statement to preload a table's index into a given key cache for a MyISAM table.
Related Functions
Below are MySQL functions related to the SQL topic selected.
ANALYSE( )
This MySQL function returns an analysis of a results table from a SELECT statement.
BENCHMARK( )
Use this MySQL function to evaluate the performance of a MySQL server.
DATABASE( )
This MySQL function returns the name of the database currently in use for the session.
FOUND_ROWS( )
Use this MySQL function in conjunction with the SQL_CALC_FOUND_ROWS option of a SELECT statement to determine the number of rows an SQL statement using a LIMIT clause would have generated without the limitation.
LAST_INSERT_ID( )
This MySQL function returns the identification number of the last row inserted using the MySQL connection.
ROW_COUNT( )
This MySQL function returns the number of rows changed by the previous SQL statement.
UUID ( )
This MySQL function returns a Universal Unique Identifier (UUID), a 128-bit number composed of five hexadecimal numbers.
VERSION( )
This MySQL function returns the MySQL server version.
SCHEMA( )
This MySQL function returns the name of the database currently in use for the session.