Error with handwritten SQL script

[janellez]

I'm trying to replace data in the products_attributes table via a mySQL REPLACE statement. It seemed easier to do it this way than product by product. I would really appreciate any advice on what I have wrong within this statement. I've included the first line of data as well (I thought I would just execute it within ZC as I find the error reporting very good. I can't figure this one out - here's the error and the code below it.)

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 ''products_attributes_id', 'products_id', 'options_id', 'options_values_id', 'opt' at line 1
in:
[REPLACE INTO products_attributes ('products_attributes_id', 'products_id', 'options_id', 'options_values_id', 'options_values_price', 'price_prefix', 'products_options_sort_order', 'product_attribute_is_free', 'products_attributes_weight', 'products_attributes_weight_prefix', 'attributes_display_only', 'attributes_default', 'attributes_discounted', 'attributes_image', 'attributes_price_base_included', 'attributes_price_onetime', 'attributes_price_factor', 'attributes_price_factor_offset', 'attributes_price_factor_onetime', 'attributes_price_factor_onetime_offset', 'attributes_qty_prices', 'attributes_qty_prices_onetime', 'attributes_price_words', 'attributes_price_words_free', 'attributes_price_letters', 'attributes_price_letters_free', 'attributes_required') VALUES ('1', '4', '1', '1', '2.44', '', '1', '1', '0.01', '', '0', '0', '1', '', '1', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0');]

[DrByte]

You can't use apostrophes to enclose field names. Either leave them out or use backquotes instead.

MAKE SURE YOU HAVE A GOOD RELIABLE BACKUP BEFORE YOU GO MESSING ABOUT WITH RAW DATABASE EDITS LIKE THAT!!!

[janellez]

Thanks - and definitely but I have tried it both ways and get errors with each.

[DrByte]

So, what error do you get if you remove all the apostrophes around the field names?
(You still need them on the values, but not the fields.)

[janellez]

You can't use apostrophes to enclose field names. Either leave them out or use backquotes instead.

MAKE SURE YOU HAVE A GOOD RELIABLE BACKUP BEFORE YOU GO MESSING ABOUT WITH RAW DATABASE EDITS LIKE THAT!!!

Thank you - this did work. I was getting an error with line one because of an error in my data to be updated.

Note - I was a little reluctant to post my question because I didn't want to give everyone license to go fooling around with mySQL. I know enough most times (sometimes enough to be dangerous) but I do know how to make a good back up and I know how to restore them as well! Thanks again!

[DrByte]

Note - I was a little reluctant to post my question because I didn't want to give everyone license to go fooling around with mySQL.

Excellent consideration.


Glad you got it working.

Now ... be careful!