SQL Query Load data into column

[mike14017]

Hi

In the product_attributes table I want to add "1" into the attributes_price_factor column but only when the value of options_values_id column is "39" using an SQL query. I have googled this but can't find exactly what I am looking for.

Could anybody help me on this please.

Thanks

Mike

[mc12345678]

Is it add 1 or set as 1?

Is it that you are wanting to UPDATE the existing data or do you want to do this when items are INSERTed?

[mike14017]

Hi

I have about 1000 items where I want to add the price offset of "1.000" and rather than do each one separately I thought it would be easier to update/insert with an SQL query

Thanks

Mike

[mc12345678]

Hi

I have about 1000 items where I want to add the price offset of "1.000" and rather than do each one separately I thought it would be easier to update/insert with an SQL query

Thanks

Mike

To increase the price offset by 1.000:
In the install sql updates window of the admn enter:

Update products_attributes set attributes_price_factor=attributes_price_factor+1 where options_values_id = 39;

[mike14017]

Hi

Worked like a charm. Thank you so much I really appreciate it.

Mike

[mc12345678]

Hi

Worked like a charm. Thank you so much I really appreciate it.

Mike

Welcome, glad it worked out and maybe you were able to figure out how to do something similar in the future. :)