Problem with Load Data Infile

[ryclem]

I am struggling with a bit of code.... essentially, I have a bunch of .csv product feeds that all may have a different number of columns... so essentially I implode the entire csv file and am then attempting to only insert records for a set number of them. I have looked and looked and the code looks right, but I keep getting the following error:

#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 'Condition,Currency,Language,ShipFrom,Keywords,SubCategory ) SET MerchantID = @me' at line 1

MySQL version = MySQL - 5.0.45

The echo of the query is as follows:

LOAD DATA LOCAL INFILE '/var/www/vhosts/domain.com/httpdocs/productfeeds/xxxxxx-pfo-020491-01of01.csv' INTO TABLE as_feeds_products_sets_misc FIELDS TERMINATED BY '|' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (

@ProductID , Categories, Title, Description, Price, URL, ThumbURL, ImageURL, Retail, InStock, ShippingWeight, UPC, Brand, Manufacturer, ManufacturerID, Classification, Condition, Currency, Language, ShipFrom, Keywords, SubCategory
) SET MerchantID = @merchantId ,
ProductID = @ProductID ,
Title = @Title ,
Description = @Description ,
TrackingURL = @URL ,
ImageURL = @ImageURL ,
Price = @Price ,
Keywords = @Keywords ;

Any thoughts would be appreciated as this is driving me nuts!!!

Thanks,
Ryan

[Weedpacket]

Have a look at the link provided in this FAQ post.

[ryclem]

I don't think that post addresses my issue?

[Weedpacket]

Yes it does: "Condition" is a reserved word.