The command line when MySQL exits the current edit error

Many times in our use of the MySQL command line process, accidentally wrong some of the commands, the current command line is not out of the "current editing mode", such as

The correct command should be:

Show variables like '%char% ';

At this point, we can enter in the next row, in the new line

'(in English mode, single quote), then enter (Note: This line you can also enter " (in English mode, double quotation marks),)

Next, enter in the new line

\c (in English mode)

To exit the current editing mode, see the diagram

Look at a complete illustration,

These prompt meanings (see bottom recommendation)

Mysql> ready to accept the new order.

Wait for the next line of the multiline command.

' > waits for the next line, waiting for the end of the string to begin with single quotation marks ("'").

> waits for the next line, waiting for the end of the string to begin with double quotation marks ("" ").

' > waits for the next line, waiting for the end of the qualifier to begin with a backslash (' ').

/*> waits for the next line, waiting for the end of the comment to start with/*.

Reference:

http://bbs.csdn.net/topics/310230600 (2009-08-17-12:58:01)

http://www.anbob.com/archives/579.html (2011/04/01) Recommended

The command line when MySQL exits the current edit error