content_image/670465.jpg content_image/670467.jpg content_image/670466.jpg
<img src='content_image/670465.jpg'>

• --help , -? 

Display a help message and exit. 

• --auto-rehash 

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. 

<img src='content_image/670467.jpg'>

• --auto-vertical-output 

<img src='content_image/670466.jpg'>

## Note 

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 .) 

• --batch , -B 

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. 

• --binary-as-hex 

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): 

• --binary-as-hex  disabled: 

