Page 1 of 1

what is wrong with this query?

Posted: Sun Jun 10, 2012 9:51 pm
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')
=================================

Re: what is wrong with this query?

Posted: Sun Jun 10, 2012 10:48 pm
by Christopher
You need to escape string being inserted as product_name.

'Schumann\'s Dichterliebe and early romantic poetics : fragmentation of desire'