MySQL client prompts

Let's take a look at some client tips provided by MySQL -

Input line editing

Mysql supports input line editing, which allows The user in-place modifies the current input line or calls a previous input line.

Disable interaction history

The up arrow key allows the user to recall input lines from the current and call. previous sessions. If the console is shared, this behavior may not be appropriate. mysql supports partial or complete disabling of interaction history, depending on the host platform.

On Windows, history is stored in memory. The "Alt F7" key will delete all input lines stored in memory in the current history buffer

Unicode support on Windows

Windows provides UTF-16LE based APIs for Read and write to the console. The mysql client for Windows can use these APIs. Windows Setup will create a project in the MySQL menu called MySQL Command Line Client - Unicode.

Display query results vertically

Some query results are more readable when displayed vertically rather than in the usual horizontal table format. You can display a query vertically by terminating it with \G instead of a semicolon.

Disable mysql automatic reconnect

If the mysql client loses connection to the server when it is sending a statement, it will immediately and automatically try to reconnect to the server once and then send again this statement.

mysql client parser vs. server parser

mysql client uses a parser on the client, which is not a copy of the full parser used by the server-side mysqld server. This may result in differences in how certain constructs are handled. Let's look at an example -

If ANSI_QUOTES SQL mode is enabled, the server parser will treat " character-delimited strings as identifiers instead of processing plain strings.

The above is the detailed content of MySQL client prompts. For more information, please follow other related articles on the PHP Chinese website!