Hello all,

First off, I have searched and searched for an answer trying to figure out how to do this and still nothing makes sense to me so I thought I would try describing my situation and seeing if anyone has an answer that I can understand.

I have a table in MySQL that I am trying to update. There are already values in the table and the primary key is products_id. There are 13 fields total in this table but I am only needing to update one of them, therefore in my spreadsheet I have the primary key (products_id) and the one I want to update (products_learnmore).

When I try to import the file as a CSV (comma delimited) I get the error:

Invalid field count in CSV input on line 1.

I'm guessing this means that it is expecting my csv file to have all 13 fields, I'm not sure though. Also, my products_learnmore field does contain commas, as it is HTML coding for product descriptions.

I have tried using csv2sql.com/ but cannot get it to work with importing SQL either. Does anyone have any ideas on how to solve this? There are about 600 products and it would take absolutely forever to edit 1 by 1

field does contain commas

CSV means COMMA separated values.

It is expecting all the extra fields. Why not export what you have in the database as a csv to get the full list and then merge the two csv files so you have all 13 fields with the one new field that needs to be updated.

Another option would be to turn your csv into sql. You'd need to turn your two fields (the one to update and the id field) into update statements

UPDATE tablename SET products_learnmore = value WHERE product_id = value;

I would think some general search and replace could take what you have and turn it into something along the lines of the update statement.