what is wrong with this query?
Posted: Sun Jun 10, 2012 9:51 pm
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')
=================================
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')
=================================