home support FAQ resources services partners contact us contact us
 MySQL Tutorial Previous  Next  
 

Table 2.1. String Escape Sequences

Sequence Meaning
\0 NUL (ASCII 0)
\' Single quote
\" Double quote
\b Backspace
\n Newline (linefeed)
\r Carriage return
\t Tab
\\ Backslash
\Z Ctrl-Z (Windows EOF character)


To include either kind of quote character within a string, you can do one of three things:

Double the quote character if the string is quoted using the same character:

'I can''t'
"He said, ""I told you so."""

Quote the string with the other quote character; in this case, you do not double the quote characters within the string:

"I can't"
'He said, "I told you so."'

Escape the quote character with a backslash; this works regardless of the quote characters used to quote the string:
Previous  Next  
Link Partners: Asia florist, Flowers to India, Hong kong flowers, Site submit, Cheap web hosting, China florist, Japan florist