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')
=================================
what is wrong with this query?
Moderator: General Moderators
- 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?
You need to escape string being inserted as product_name.
'Schumann\'s Dichterliebe and early romantic poetics : fragmentation of desire'
'Schumann\'s Dichterliebe and early romantic poetics : fragmentation of desire'
(#10850)