mysql is a simple SQL shell with input line editing capabilities. It supports interactive and noninteractive use. When used interactively, query results are presented in an ASCII-table format. When used noninteractively (for example, as a filter), the result is presented in tab-separated format. The output format can be changed using command options.
If you have problems due to insufficient memory for large result
sets, use the
--quick option. This
forces mysql to retrieve results from the
server a row at a time rather than retrieving the entire result
set and buffering it in memory before displaying it. This is
done by returning the result set using the
mysql_use_result() C API
function in the client/server library rather than
Alternatively, MySQL Shell offers access to the X DevAPI. For details, see MySQL Shell 8.0.
Using mysql is very easy. Invoke it from the prompt of your command interpreter as follows:
mysql --user=user_name --password db_name
In this case, you'll need to enter your password in response to the prompt that mysql displays:
Enter password: your_password
Then type an SQL statement, end it with
\G and press Enter.
Typing Control+C interrupts the current statement if there is one, or cancels any partial input line otherwise.
You can execute SQL statements in a script file (batch file) like this:
mysql db_name < script.sql > output.tab
On Unix, the mysql client logs statements executed interactively to a history file. See Section 126.96.36.199, “mysql Client Logging”.