problem when insert "\\" in MySQL table

Question

when i insert a specific value in MySQL table through code i get exception (1064 error)

i know the reason , but i don't know how to fix the problem,, all what i wanna to do is to store the relative path of my images in the image table then i get this exception all the time when the inserted string contains "\" or @"\".

how can i fix this problem

Answer 1

Chances are you're embedding the values directly into your SQL. Don't do that: use a parameterized query instead, which will keep your SQL code separate from the data. This means you don't need to worry about formatting values or SQL injection attacks, and lets you reuse statements.