獲得 mysql幫助[@more@]

mysql> help contents; ? contents

You asked for help about help category: "Contents"

For more information, type 'help ', where is one of the following

categories:

Account Management

Administration

Compound Statements

Data Definition

Data Manipulation

Data Types

Functions

Functions and Modifiers for Use with GROUP BY

Geographic Features

Help Metadata

Language Structure

Plugins

Procedures

Storage Engines

Table Maintenance

Transactions

User-Defined Functions

Utility

mysql> help administration;

mysql> help show create table;

mysql> ? data types;

mysql> ? char

mysql> ?

? (?) Synonym for `help'.

clear (c) Clear the current input statement.

connect (r) Reconnect to the server. Optional arguments are db and host.

delimiter (d) Set statement 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. 控制翻屏 pager less| pager more

print (p) Print current command.

prompt (R) Change your mysql prompt.

quit (q) Quit mysql.

rehash (#) Rebuild completion hash. 自動補全命令，在引數檔案 my.cnf的mysql 中設定

source (.) Execute an SQL script file. Takes a file name as an argument. 類似於oracle中的 @

status (s) Get status information from the server. 常用命令

system (!) Execute a system shell command.

mysql> system ls

tee (T) Set outfile [to_outfile]. Append everything into given outfile.

mysql> tee /u02/use.txt

Logging to file '/u02/use.txt'

mysql> notee

Outfile disabled.

use (u) Use another database. Takes database name as argument.

charset (C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.

mysql> charset gbk;

warnings (W) Show warnings after every statement.

nowarning (w) Don't show warnings after every statement.

For server side help, type 'help contents'

mysql-5.1.68獲得幫助

相關文章