mysql — The MySQL Command-Line Client Display a help message and exit. Enable automatic rehashing. This option is on by default, which enables database, table, and column name completion. Use  --disable-auto-rehash  to disable rehashing. That causes  mysql  to start faster, but you must issue the  rehash  command or its  \#  shortcut if you want to use name completion. To complete a name, enter the first part and press Tab. If the name is unambiguous,  mysql  completes it. Otherwise, you can press Tab again to see the possible names that begin with what you have typed so far. Completion does not occur if there is no default database. This feature requires a MySQL client that is compiled with the  readline  library. Typically, the  readline  library is not available on Windows. Cause result sets to be displayed vertically if they are too wide for the current window, and using normal tabular format otherwise. (This applies to statements terminated by  ;  or  \G .) Print results using tab as the column separator, with each row on a new line. With this option,  mysql does not use the history file. Batch mode results in nontabular output format and escaping of special characters. Escaping may be disabled by using raw mode; see the description for the  --raw  option. When this option is given,  mysql  displays binary data using hexadecimal notation ( 0x value ). This occurs whether the overall output display format is tabular, vertical, HTML, or XML. --binary-as-hex  when enabled affects display of all binary strings, including those returned by functions such as  CHAR()  and  UNHEX() . The following example demonistrates this using the ASCII code for  A  (65 decimal, 41 hexadecimal): • --help ,  -? • --auto-rehash • --auto-vertical-output • --batch ,  -B • --binary-as-hex • --binary-as-hex  disabled: 420 Note Option Name Description Introduced Deprecated --vertical Print query output rows vertically (one line per column value) --wait If the connection cannot be established, wait and retry instead of aborting --xml Produce XML output --zstd-compression-level Compression level for connections to server that use zstd compression 8.0.18