/0
An ASCII 0 (NUL) character.
/N
A newline character.
/T
A positioning character.
/R
A carriage return.
/B
A return character.
/'
A single quotation mark.
/"
A double quotation mark.
//
A backslash.
/%
A "%" character. It is used to search for the text instance of "%" in the body. Otherwise, "%" is interpreted as a wildcard.
/_
A "_" character. It is used to search for the text instance of "_" in the body. Otherwise, "_" is interpreted as a wildcard.
Note: If you use "/%" or "/% _" in some body environments _", these will return strings "/%" and "/_" instead of "%" and "_".
★★
There are several methods to enclose quotation marks in a string:
1. Escape:
A string is referenced by a single quotation mark ('). The single quotation mark (') character in the string can be escaped by a single quotation mark.
A string is referenced by double quotation marks (""). The character "" In this string can be escaped.
At the same time, you can continue to use an escape character "/" to escape
2. Escape-free:
A string is referenced by double quotation marks (""). The single quotation marks (') in the string do not need to be treated specially and do not need to be repeated or escaped.
Likewise,
A string is referenced by single quotation marks ('). The double quotation marks ("") in the string do not need to be treated specially and do not need to be repeated or escaped.
The following SELECT statement demonstrates how quotes and escaping work:
Mysql> select "This/NIS/nfour/nlines ";
+ -------------------- +
Else this
Is
Four
Lines
+ -------------------- +
★★
If you want to insert binary data into a blob column, the following characters must be represented by escape sequences:
Nul
ASCII 0. You should use '/0' (a backslash and an ASCII '0') to represent it.
/
ASCII 92, backslash. .
'
ASCII 39, single quotes. It is represented.
"
ASCII 34, double quotation marks. It is represented.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.