The escape character of MySQL "\"

/

an ASCII 0 (NUL)    characters.

\ n

A new line character.

\ t

A locator character.

\ r

A carriage return character.

\b

A backspace.

\‘

a single quotation mark ("'")    characters.

\  "

a double quotation mark ("" ")    characters.

\\

a backslash ("\")    characters.

\%

a "% "character.    It is used to search for "%" text instances in the body, otherwise "%" herewill be interpreted as a wildcard character.

\_

Select ' Ab\ ' AB ' as a, ' ab\ ' ab ' as B, ' Ab\tab ' as C, ' Ab\bab ' as D, ' Ab\\ab ' as E, ' Ab\\\\ab ' as F, ' Ab\nab ' as G;

If you want to insert binary data into a blob column, the following characters must be represented by an escape sequence:

NUL ASCII 0 .    You should use '/' (a backslash and an ASCII ' 0 ') to represent it.

\ ASCII , backslash.  Use ' \ \ ' to indicate.

' ASCII , single quotation marks.    Use ' \ ' to indicate.

"ASCII 34, double quotes. denoted by ' \ '.

The escape character of MySQL "\"