MySql: Update a field with a content made up with special character such '\'

Hello mates,
The following sql statement does not work
Update param_email Set pdf_folder = 'c:\autre'
It looks like \ character is not supported.
What can I do this updated exactly the way I put it.
I am looking forward to hearing from you.
Omer-Pitou
Omer-PitouAsked:
Who is Participating?
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
This page shows how to 'escape' the characters you want in a string.  http://dev.mysql.com/doc/refman/5.0/en/string-literals.html  In the case above, it would be 'c:\\autre'.
0
All Courses

From novice to tech pro — start learning today.