MySQL Special Character Escape Sequences
941 ワード
Escape Sequence
Character Represented by Sequence
An ASCII NUL (
A single quote (“
A double quote (“
A backspace character.
A newline (linefeed) character.
A carriage return character.
A tab character.
ASCII 26 (Control+Z). See note following the table.
A backslash (“
A “
A “
http://dev.mysql.com/doc/refman/5.1/en/string-syntax.html
Character Represented by Sequence
\0 An ASCII NUL (
0x00 ) character. \' A single quote (“
' ”) character. \" A double quote (“
" ”) character. \b A backspace character.
A newline (linefeed) character.
\r A carriage return character.
\t A tab character.
\Z ASCII 26 (Control+Z). See note following the table.
\\ A backslash (“
\ ”) character. \% A “
% ” character. See note following the table. \_ A “
_ ” character. See note following the table. http://dev.mysql.com/doc/refman/5.1/en/string-syntax.html