MySQL ? 帮助的使用mysql> ?contents;
You asked for helpabout help category: "Contents"
For more information,type 'help <item>', where <item> is one of the following
categories:
Account Management
Administration
Data Definition
Data Manipulation
Data Types
Functions
Functions and Modifiers for Use with GROUPBY
Geographic Features
Language Structure
Storage Engines
Stored Routines
Table Maintenance
Transactions
Triggers
mysql> ?data definition
You asked for helpabout help category: "Data Definition"
For more information,type 'help <item>', where <item> is one of the following
topics:
ALTER DATABASE
ALTER TABLE
ALTER VIEW
CONSTRAINT
CREATE DATABASE
CREATE INDEX
CREATE TABLE
CREATE VIEW
DROP DATABASE
DROP INDEX
DROP TABLE
DROP VIEW
MERGE
RENAME TABLE
mysql> ?
For information aboutMySQL products and services, visit:
http://www.mysql.com/
For developerinformation, including the MySQL Reference Manual, visit:
http://dev.mysql.com/
To buy MySQL Enterprisesupport, training, or other products, visit:
https://shop.mysql.com/
List of all MySQLcommands:
Note that all textcommands must be first on line and end with ';'
? (\?) Synonym for `help'.
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optionalarguments are db and host.
delimiter (\d) Setstatement 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 queryresults via PAGER.
print (\p) Print current command.
prompt (\R) Change your mysql prompt.
quit (\q) Quit mysql.
rehash (\#) Rebuild completion hash.
source (\.) Execute an SQL script file. Takes afile name as an argument.
status (\s) Get status information from theserver.
system (\!) Execute a system shell command.
tee (\T) Set outfile [to_outfile]. Appendeverything into given outfile.
use (\u) Use another database. Takes databasename as argument.
charset (\C) Switch to another charset. Might beneeded for processing binlog with multi-byte charsets.
warnings (\W) Show warnings after every statement.
nowarning (\w) Don'tshow warnings after every statement.
For server side help, type 'helpcontents'
mysql> help contest;
Nothing found
Please try to run 'helpcontents' for a list of all accessible topics
mysql> help contents
You asked for helpabout help category: "Contents"
For more information,type 'help <item>', where <item> is one of the following
categories:
Account Management
Administration
Compound Statements
Data Definition
Data Manipulation
Data Types
Functions
Functions and Modifiers for Use with GROUPBY
Geographic Features
Help Metadata
Language Structure
Table Maintenance
Transactions
User-Defined Functions
Utility
mysql> help data types
mysql> ? data types
