Mysql Official site | Mysql Programs ＞ Client Programs

This section describes client programs that connect to the MySQL server.

mysql — The MySQL Command-Line Client

mysql is a simple SQL shell with input line editing capabilities.

它支持交互式和非交互式使用。 交互使用时，查询结果以 ASCII 表格式显示。 当以非交互方式使用时（例如，作为过滤器），结果以制表符分隔的格式显示。 可以使用命令选项更改输出格式。

Using mysql is very easy. Invoke it from the prompt of your command interpreter as follows:

mysql db_name

Or:

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, or \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