How to end the command in mysql

MySQL commands can be ended in four ways: semicolon (;) to execute the command, backslash () to span multiple lines, Ctrl-C to force the end, and exit to exit the client.

How to end a MySQL command

MySQL command can be ended in the following ways:

1. Semicolon (;)

The most common method is to use semicolon (;). After entering the command, hit the semicolon to execute the command.

For example:

<code>mysql> SELECT * FROM users;</code>

2. Backslash ()

Backslash () can also be used to end a command. It allows commands to span multiple lines. For example:

<code>mysql> SELECT * FROM users \
> WHERE name = 'John';</code>

3. Ctrl-C

You can press the Ctrl-C key at the command prompt to forcefully end the command. This is particularly useful for canceling long running queries.

4. exit

Use the exit command to exit the MySQL client.

For example:

<code>mysql> exit</code>

The above is the detailed content of How to end the command in mysql. For more information, please follow other related articles on the PHP Chinese website!