Category Image MySQL built-in help


When I was upgrading from 4.0 to 4.1 I noticed the internal 'mysql' database had tables of reference data. This allows clients to get help directly from the server instead of browsign the online docs at mysql.com. This is convenient when you are not connected to the internet.....

For example, log into any mysql 4.1 server using your terminal and do this:
mysql> help select
Name: 'SELECT'
Description:
Syntax:
SELECT
[ALL | DISTINCT | DISTINCTROW ]
[HIGH_PRIORITY]
[STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
select_expr, ...
[FROM table_references
[WHERE where_definition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_definition]
[ORDER BY {col_name | expr | position}
[ASC | DESC] , ...]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
[PROCEDURE procedure_name(argument_list)]
[INTO OUTFILE 'file_name' export_options
| INTO DUMPFILE 'file_name']
[FOR UPDATE | LOCK IN SHARE MODE]]

SELECT is used to retrieve rows selected from one or more tables.
Support for UNION statements and subqueries is available as of MySQL
4.0 and 4.1, respectively. See [union], and [subqueries].

o Each select_expr indicates a column you want to retrieve.

o table_references indicates the table or tables from which to retrieve
rows. Its syntax is described in [join].

o where_definition consists of the keyword WHERE followed by an
expression that indicates the condition or conditions that rows must
satisfy to be selected.

SELECT can also be used to retrieve rows computed without reference to
any table.


just great!

Posted: Thursday - November 02, 2006 at 03:19 PM        

Published by