Escape Sequences Used In MySQL

From the MySQL website:

For input, if the FIELDS ESCAPED BY character is not empty, occurrences of that character are stripped and the following character is taken literally as part of a field value. Some two-character sequences that are exceptions, where the first character is the escape character. These sequences are shown in the following table (using “\” for the escape character). The rules for NULL handling are described later in this section.

\0 An ASCII NUL (0x00) character
\b A backspace character
\n A newline (linefeed) character
\r A carriage return character
\t A tab character.
\Z ASCII 26 (Control-Z)

For more information about “\”-escape syntax, see Section 8.1, “Literal Values”.

Posted under Freeware, MySQL

Comments are closed.

More Articles: