what is wrong with this query?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
wvoyance
Forum Contributor
Posts: 135
Joined: Tue Apr 17, 2012 8:24 pm

what is wrong with this query?

Post by wvoyance »

This error message sometimes pop up...What does it complaining?
The error message is
=====================
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 's Dichterliebe and early romantic poetics : fragmentation of desire','form:BA
====================================
This was my command
====================================
INSERT ignore INTO products_description(products_id, language_id, products_name, products_description, products_url, extra_value2, extra_value3) VALUES ('591','1','Schumann's Dichterliebe and early romantic poetics : fragmentation of desire','form:BA
language:eng
edition:1. publ.
city:Cambridge [u.a.]
','www.worldcat.org/oclc/216907062?referer=xid','Beate Julia Perrey.','2002')
=================================
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: what is wrong with this query?

Post by Christopher »

You need to escape string being inserted as product_name.

'Schumann\'s Dichterliebe and early romantic poetics : fragmentation of desire'
(#10850)
Post Reply