mysql> help

For the complete MySQL Manual online, visit:
   http://www.mysql.com/documentation

For info on technical support from MySQL developers, visit:
   http://www.mysql.com/support

For info on MySQL books, utilities, consultants, etc., visit:
   http://www.mysql.com/portal

List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
?         (\?) Synonym for `help'.
clear     (\c) Clear command.
connect   (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter. NOTE: Takes the rest of the line as new delimiter.
edit      (\e) Edit command with $EDITOR.
ego       (\G) Send command to mysql server, display result vertically.
exit      (\q) Exit mysql. Same as quit.
go        (\g) Send command to mysql server.
help      (\h) Display this help.
nopager   (\n) Disable pager, print to stdout.
notee     (\t) Don't write into outfile.
pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print     (\p) Print current command.
prompt    (\R) Change your mysql prompt.
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute a SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command.
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
use       (\u) Use another database. Takes database name as argument.
warnings  (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.

For server side help, type 'help contents'

mysql> help contents
You asked for help about help category: "Contents"
For more information, type 'help ', where  is one of the following
categories:
   Administration
   Column Types
   Data Definition
   Data Manipulation
   Functions
   Geographic features
   Transactions

mysql> help functions
You asked for help about help category: "Functions"
For more information, type 'help ', where  is one of the following
topics:
   CHAR BYTE
   DUAL
   FUNCTION
   TRUE FALSE
categories:
   Bit Functions
   Comparison operators
   Control flow functions
   Date and Time Functions
   Encryption Functions
   Functions and Modifiers for Use with GROUP BY Clauses
   Information Functions
   Logical operators
   Miscellaneous Functions
   Numeric Functions
   String Functions

mysql> help string functions
You asked for help about help category: "String Functions"
For more information, type 'help ', where  is one of the following
topics:
   ASCII
   BIN
   BINARY OPERATOR
   BIT_LENGTH
   CAST
   CHAR FUNCTION
   CHARACTER_LENGTH
   CHAR_LENGTH
   COMPRESS
   CONCAT
   CONCAT_WS
   CONV
   ELT
   EXPORT_SET
   FIELD
   FIND_IN_SET
   HEX
   INSERT
   INSTR
   LCASE
   LEFT
   LENGTH
   LIKE
   LOAD_FILE
   LOCATE
   LOWER
   LPAD
   LTRIM
   MAKE_SET
   MATCH AGAINST
   MID
   NOT LIKE
   NOT REGEXP
   OCT
   OCTETLENGTH
   ORD
   POSITION
   QUOTE
   REPEAT
   REPLACE
   REVERSE
   RIGHT
   RLIKE
   RPAD
   RTRIM
   SOUNDEX
   SOUNDS LIKE
   SPACE
   STRCMP
   SUBSTRING
   SUBSTRING_INDEX
   TRIM
   UCASE
   UNCOMPRESS
   UNCOMPRESSED_LENGTH
   UNHEX
   UPPER

mysql> help upper
Name: 'UPPER'
Description:
   UPPER(str)
Returns the string str with all characters changed to uppercase
according to the current character set mapping (the default is ISO-8859-1
Latin1).
Examples:
mysql> SELECT UPPER('Hej');
        -> 'HEJ'

© Copyright 2006. ARABX Pty Ltd.