• --print-defaults 

Print the program name and all options that it gets from option files. 

For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . 

• --prompt= format_str 

Set the prompt to the specified format. The default is mysql> . The special sequences that the prompt can contain are described in Section 4.5.1.2, “mysql Client Commands” . 

• --protocol={TCP|SOCKET|PIPE|MEMORY} 

The transport protocol to use for connecting to the server. It is useful when the other connection parameters normally result in use of a protocol other than the one you want. For details on the permissible values, see Section 4.2.7, “Connection Transport Protocols” . 

• --quick , -q 

Do not cache each query result, print each row as it is received. This may slow down the server if the output is suspended. With this option, mysql  does not use the history file. 

• --raw , -r 

For tabular output, the “boxing”  around columns enables one column value to be distinguished from another. For nontabular output (such as is produced in batch mode or when the --batch  or --silent option is given), special characters are escaped in the output so they can be identified easily. Newline, tab, NUL , and backslash are written as 
 , 	 , \0 , and \\ . The --raw  option disables this character escaping. 

The following example demonstrates tabular versus nontabular output and the use of raw mode to disable escaping: 

% mysql mysql> SELECT CHAR(92); +----------+ | CHAR(92) | +----------+ | \ | +----------+ % mysql -s mysql> SELECT CHAR(92); CHAR(92) \\ % mysql -s -r mysql> SELECT CHAR(92); CHAR(92) \ 

• --reconnect 

If the connection to the server is lost, automatically try to reconnect. A single reconnect attempt is made each time the connection is lost. To suppress reconnection behavior, use --skip-reconnect . 

• --safe-updates , --i-am-a-dummy , -U 

If this option is enabled, UPDATE  and DELETE  statements that do not use a key in the WHERE  clause or a LIMIT  clause produce an error. In addition, restrictions are placed on SELECT  statements that produce 

