CINXE.COM
MySQL - SS64.com
<!doctype html><html lang="en"> <head><meta charset="UTF-8"> <meta name="viewport" content="width=768, initial-scale=1"> <link rel="stylesheet" href="../main.css" type="text/css"> <link rel="icon" href="/favicon.ico" sizes="48x48"> <link rel="icon" href="/favicon.svg" sizes="any" type="image/svg+xml"> <link rel="canonical" href="https://ss64.com/mysql/"> <title>MySQL - SS64.com</title> <meta name="Description" content="MySQL database"> <link rel="search" href="https://ss64.com/opensearchdescription.xml" type="application/opensearchdescription+xml" title="SS64.com"> <style> #sql {color: #0099ff;} </style> </head> <body> <div id="tnav"><ul> <li class="tbtn"><a href="../">SS64</a></li> <li class="tbtn"><a href="../databases.html">Databases <svg viewBox="0 0 13 20.1" width="13" height="13" style="transform: rotate(0deg);"><path d="M0 2.9l7.2 7.2-7.1 7.1L3 20.1l7.1-7.1 2.9-2.9L2.9 0 0 2.9"></path></svg></a></li> <li><div id="search"><form action="https://www.google.com/search" method="get"> <input type="text" name="q" id="qu" size="27" maxlength="255"> <input class="submit mousetrap" value="Search" id="btn" type="submit"> <input type="hidden" name="sitesearch" value="ss64.com"><input type="hidden" name="udm" value="14"></form></div></li> </ul></div> <h1>The <span id="sql">MySql</span> database</h1> <pre>Syntax mysql.exe [<i>OPTIONS</i>] [<i>database</i>] Key: --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. -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. -B, --batch Don't use history file. Disable interactive behavior. (Enables --silent.) --character-sets-dir=<i>name</i> 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, --compress Use compression 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=<i>name</i> Database to use. --default-character-set=<i>name</i> Set the default character set. --delimiter=<i>name</i> Delimiter to be used. -e, --execute=<i>name</i> 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鈥檚 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. --disable-named-commands Disable named commands. This option is disabled by default. -g, --no-named-commands Disable named commands. Use \* form only, or use named commands only in the beginning of a line ending with a semicolon (;). Since version 10.9, the client now starts with this option ENABLED by default. Disable with '-G'. Long format commands still work from the first line. WARNING: option deprecated; use --disable-named-commands instead. -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=<i>name</i> 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. -n, --unbuffered 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=<i>name</i> Change the value of a variable. Please note that this option is deprecated; you can set variables directly with --variable-name=value. --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[=<i>name</i>] Password to use when connecting to server. If password is not given it鈥檚 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 preference, my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default (3306). --prompt=<i>name</i> Set the mysql prompt to this value. --protocol=<i>name</i> 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. -s, --silent Be more silent. Print results with a tab as separator, each row on new line. --shared-memory-base-name=<i>name</i> Base name of shared memory. -S, --socket=<i>name</i> The socket file to use for connection. --ssl Enable SSL for connection (automatically enabled with other flags).Disable with --skip-ssl. --ssl-ca=<i>name</i> CA file in PEM format (check OpenSSL docs, implies --ssl). --ssl-capath=<i>name</i> CA directory (check OpenSSL docs, implies --ssl). --ssl-cert=<i>name</i> X509 cert in PEM format (implies --ssl). --ssl-cipher=<i>name</i> SSL cipher to use (implies --ssl). --ssl-key=<i>name</i> X509 key in PEM format (implies --ssl). --ssl-verify-server-cert Verify server鈥檚 "Common Name" in its cert against hostname used when connecting. This option is disabled by default. -t, --table Output in table format. --tee=<i>name</i> 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. --no-tee Disable outfile. See interactive help (\h) also. WARNING: Option deprecated; use --disable-tee instead. -u, --user=<i>name</i> 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 (pre-4.1.1) protocol. --server-arg=<i>name</i> Send embedded server this as a parameter. --show-warnings Show warnings after every statement. -?, --help Display help and exit. -I, --help Synonym for -?</pre> <h2>Default options</h2> <blockquote> <p>The default options are read from the '<span class="code">my.ini</span> and <span class="code">my.cnf</span>' files.</p> <p>The following options may be given as the first argument:</p> <pre>--print-defaults Print the program argument list and exit. --no-defaults Don't read default options from any option file. --defaults-file=<i>#</i> Only read default options from the given file #. --defaults-extra-file=<i>#</i> Read this file after the global files are read.</pre> </blockquote> <h3><b>Examples</b></h3> <p>Connect to the database 'ss64database' using the username/password user64/pa55w0rd :</p> <p class="code">./mysql -u user64 --password=pa55w0rd ss64database</p> <p>Connect to the same database and run a query, line breaks added for clarity, but this would all be in one command line:</p> <pre>./mysql -u user64 --password=pa55w0rd -e "SELECT ips_Concat3(YEAR(T_log.LogTime),'-',MONTH(T_log.LogTime),'-',DAY(T_log.LogTime)) AS dtm, CASE T_log.Action WHEN 'file_upload' THEN 'Upload' WHEN 'file_download' THEN 'Download' ELSE T_log.Action END AS UpDown FROM T_log ORDER BY YEAR(T_log.LogTime),MONTH(T_log.LogTime), DAY(T_log.LogTime)' " ss64database</pre> <h3>Related</h3> <p><a href="variables.html">MySQL Variables</a> (--variable-name=<i>value</i>)</p><!-- #BeginLibraryItem "/Library/foot_menu.lbi" --><hr> <div id=bl> </div> <div id=br>Copyright © 1999-2024 <a href="https://ss64.com/">SS64.com</a><br> Some rights reserved</div><!-- #EndLibraryItem --> </body> </html>