Solved

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

Posted on 2013-05-19
1
322 Views
Last Modified: 2013-05-19
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
0
Comment
Question by:Omer-Pitou
1 Comment
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 39178206
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question