如何将mysql联网_最全mysql命令

软件安装：装机软件必备包

SQL是Structured Query Language(结构化查询语言)的缩写。SQL是专为数据库而建立的操作命令集，是一种功能齐全的数据库语言。在使用它时，只需要发出“做什么”的命令，“怎么做”是不用使用者考虑的。SQL功能强大、简单易学、使用方便，已经成为了数据库操作的基础，并且现在几乎所有的数据库均支持SQL。本篇文章主要介绍mysql的命令，感兴趣的朋友参考下，希望对大家有所帮助。

C:\Users\Administrator>mysql --help

mysql Ver 14.14 Distrib 5.5.27, for Win32 (x86)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Usage: mysql [OPTIONS] [database]

-?, --help Display this help and exit.

-I, --help Synonym for -?

--auto-rehash Enable automatic rehashing. One doesn't need to use

'rehash' to get table and field completion, but startup

and reconnecting may take a longer time. Disable with

--disable-auto-rehash.

(Defaults to on; use --skip-auto-rehash to disable.)

-A, --no-auto-rehash

No automatic rehashing. One has to use 'rehash' to get

table and field completion. This gives a quicker start of

mysql and disables rehashing on reconnect.

--auto-vertical-output

Automatically switch to vertical output mode if the

result is wider than the terminal width.

-B, --batch Don't use history file. Disable interactive behavior.

(Enables --silent.)

--character-sets-dir=name

Directory for character set files.

--column-type-info Display column type information.

-c, --comments Preserve comments. Send comments to the server. The

default is --skip-comments (discard comments), enable

with --comments.

-C, --comdivss Use comdivssion in server/client protocol.

-#, --debug[=#] This is a non-debug version. Catch this and exit.

--debug-check Check memory and open file usage at exit.

-T, --debug-info Print some debug info at exit.

-D, --database=name Database to use.

--default-character-set=name

Set the default character set.

--delimiter=name Delimiter to be used.

--enable-cleartext-plugin

Enable/disable the clear text authentication plugin.

-e, --execute=name Execute command and quit. (Disables --force and history

file.)

-E, --vertical Print the output of a query (rows) vertically.

-f, --force Continue even if we get an SQL error.

-G, --named-commands

Enable named commands. Named commands mean this program's

internal commands; see mysql> help . When enabled, the

named commands can be used from any line of the query,

otherwise only from the first line, before an enter.

Disable with --disable-named-commands. This option is

disabled by default.

-i, --ignore-spaces Ignore space after function names.

--init-command=name SQL Command to execute when connecting to MySQL server.

Will automatically be re-executed when reconnecting.

--local-infile Enable/disable LOAD DATA LOCAL INFILE.

-b, --no-beep Turn off beep on error.

-h, --host=name Connect to host.

-H, --html Produce HTML output.

-X, --xml Produce XML output.

--line-numbers Write line numbers for errors.

(Defaults to on; use --skip-line-numbers to disable.)

-L, --skip-line-numbers

Don't write line number for errors.

-n, --unbuffered Flush buffer after each query.

--column-names Write column names in results.

(Defaults to on; use --skip-column-names to disable.)

-N, --skip-column-names

Don't write column names in results.

--sigint-ignore Ignore SIGINT (CTRL-C).

-o, --one-database Ignore statements except those that occur while the

default database is the one named at the command line.

-p, --password[=name]

Password to use when connecting to server. If password is

not given it's asked from the tty.

-W, --pipe Use named pipes to connect to server.

-P, --port=# Port number to use for connection or 0 for default to, in

order of divference, my.cnf, $MYSQL_TCP_PORT,

/etc/services, built-in default (3306).

--prompt=name Set the mysql prompt to this value.

--protocol=name The protocol to use for connection (tcp, socket, pipe,

memory).

-q, --quick Don't cache result, print it row by row. This may slow

down the server if the output is suspended. Doesn't use

history file.

-r, --raw Write fields without conversion. Used with --batch.

--reconnect Reconnect if the connection is lost. Disable with

--disable-reconnect. This option is enabled by default.

(Defaults to on; use --skip-reconnect to disable.)

-s, --silent Be more silent. Print results with a tab as separator,

each row on new line.

--shared-memory-base-name=name

Base name of shared memory.

-S, --socket=name The socket file to use for connection.

--ssl Enable SSL for connection (automatically enabled with

other flags).

--ssl-ca=name CA file in PEM format (check OpenSSL docs, implies

--ssl).

--ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).

--ssl-cert=name X509 cert in PEM format (implies --ssl).

--ssl-cipher=name SSL cipher to use (implies --ssl).

--ssl-key=name X509 key in PEM format (implies --ssl).

--ssl-verify-server-cert

Verify server's "Common Name" in its cert against

hostname used when connecting. This option is disabled by

default.

-t, --table Output in table format.

--tee=name Append everything into outfile. See interactive help (\h)

also. Does not work in batch mode. Disable with

--disable-tee. This option is disabled by default.

-u, --user=name User for login if not current user.

-U, --safe-updates Only allow UPDATE and DELETE that uses keys.

-U, --i-am-a-dummy Synonym for option --safe-updates, -U.

-v, --verbose Write more. (-v -v -v gives the table output format).

-V, --version Output version information and exit.

-w, --wait Wait and retry if connection is down.

--connect-timeout=# Number of seconds before connection timeout.

--max-allowed-packet=#

The maximum packet length to send to or receive from

server.

--net-buffer-length=#

The buffer size for TCP/IP and socket communication.

--select-limit=# Automatic limit for SELECT when using --safe-updates.

--max-join-size=# Automatic limit for rows in a join when using

--safe-updates.

--secure-auth Refuse client connecting to server if it uses old

(div-4.1.1) protocol.

--server-arg=name Send embedded server this as a parameter.

--show-warnings Show warnings after every statement.

--plugin-dir=name Directory for client-side plugins.

--default-auth=name Default authentication client-side plugin to use.

Default options are read from the following files in the given order:

C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf C:\Program Files (x86)\M

ySQL\MySQL Server 5.5\my.ini C:\Program Files (x86)\MySQL\MySQL Server 5.5\my.cn

f

The following groups are read: mysql client

The following options may be given as the first argument:

--print-defaults Print the program argument list and exit.

--no-defaults Don't read default options from any option file.

--defaults-file=# Only read default options from the given file #.

--defaults-extra-file=# Read this file after the global files are read.

Variables (--variable-name=value)

and boolean options {FALSE