Re: Backslash "\" in query

[gerald_clark]

Jeff Burgoon wrote:
Why does selecting backslash give me an error?
select "\"
gives me...
#1064 - You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'"\"' at line 1

select "/"
returns "/"

select "\\"
returns "\"
What's the deal w/ backslash?
backslash is used to signify that the following character is part of the 
data, not a special character.
It is used to include the double quotes in the string.
Ex:
select "Mary said \"You can quote me on that.\""
See the special characters section of the manual.


 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]