MySQL [OPTIONS]
-?, --help, -I
-?, --help, -I
Display help.--auto-rehash
Enable automatic rehashing. Disable with --disable-auto-rehash.-A, --no-auto-rehash
No automatic rehashing.-B, --batch
WARNING: options deprecated; use --disable-auto-rehash instead.
Don't use history file. Disable interactive behavior.--character-sets-dir=name
Directory where character sets are.--default-character-set=name
Set the default character set.-C, --compress
Use compression in server/client protocol.-#, --debug[=#]
This is a non-debug version. Catch this and exit-D, --database=name
Database to use.--delimiter=name
Delimiter to be used.-e, --execute=name
Execute command and quit.-E, --vertical
Print the output of a query (rows) vertically.-f, --force
Continue even if we get an sql error.-g, --no-named-commands
Named commands are disabled.-G, --named-commands
WARNING: option deprecated; use --disable-named-commands instead.
Enable named commands.-i, --ignore-spaces
Ignore space after function names.--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.-L, --skip-line-numbers
Don't write line number for errors.--no-tee
WARNING: -L is deprecated, use long version of this option instead.
Disable outfile.-n, --unbuffered
WARNING: option deprecated; use --disable-tee instead
Flush buffer after each query.--column-names
Write column names in results.-N, --skip-column-names
Don't write column names in results.-O, --set-variable=name
WARNING: -N is deprecated, use long version of this options instead.
Change the value of a variable. Please note that this--sigint-ignore
WARNING: option is deprecated;
Ignore SIGINT (CTRL-C)-o, --one-database
Only update the default database.-p, --password[=name]
Password to use when connecting to server.-W, --pipe
Use named pipes to connect to server.-P, --port=#
Port number to use for connection.--prompt=name
Set the mysql prompt to this value.--protocol=name
The protocol of connection (tcp,socket,pipe,memory).-q, --quick
Don't cache result, print it row by row.-r, --raw
Write fields without conversion. Used with --batch.--reconnect
Reconnect if the connection is lost. Disable with --disable-reconnect.-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
Socket file to use for connection.-t, --table
Output in table format.-T, --debug-info
Print some debug info at exit.--tee=name
Append everything into outfile.-u, --user=name
User for login if not current user.-U, --safe-updates, --i-am-a-dummy
Only allow UPDATE and DELETE that uses keys.-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=#
Max packet length to send to, or receive from server--net_buffer_length=#
Buffer 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 protocol--print-defaults
Print the program argument list and exit--no-defaults
Don't read default options from any options file--defaults-file=#
Only read default options from the given file #--defaults-extra-file=#
Read this file after the global files are read
jonw66
like this
