MySQL recognizes the following escape sequences. : String : Data Types MySQL TUTORIALS

MySQL TUTORIALS » Data Types » String »

MySQL recognizes the following escape sequences.

	An ASCII 0 (NUL) character.
'	A single quote (') character.
"	A double quote (") character.
b	A backspace character.
n	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.


mysql>
mysql>
mysql> SELECT 'ThisnIsnFournLines';
+--------------------+
| This
Is
Four
Lines |
+--------------------+
| This
Is
Four
Lines |
+--------------------+
1 row in set (0.00 sec)

mysql>
mysql>