Updating Attributes through SQL

[howb]

Hi,

I used Easy Populate to update some prices for attributes, but Easy Populate dosn't seem to agree with attributes and messed them up a bit. It reset all images and setting associated with them. I have updated the image for all the products by using the SQL code:

UPDATE products_attributes SET attributes_image = 'attributes/personalised blank red-wine.jpg' WHERE options_id = 1 and options_values_id = 9;


but I want to update the attribute to be selected by default for all products...im guessing the code is something similar;

UPDATE products_attributes SET (**make attribute default**) WHERE options_id = 1 and options_values_id = 9;

does anyone know what to put into (**make attribute defualt**)???

thanks in advance!

[howb]

does anybody have any idea? ...maybe you do not understand my question?!

I just need to know the SQL command to make an attribute option selected by default...

[Ajeh]

Are you referring to the field:
attributes_default

in the table:
products_attributes

and that you want to set it to:
1

when the options_id is set to :
XX

and the options_values_id is set to:
XX

[howb]

Thanks for the reply...Yeah, I think that what i'm looking for...


therefore, using my limited brain power, will it be...


UPDATE products_attributes SET attributes_default = 1 WHERE options_id = 1 and options_values_id = 9;

please correct me if i'm wrong?

thanks

[Ajeh]

Providing those are the correct values then yes, that is the correct SQL ...

I question the values as you used those for colors earlier ...

Make sure that the Option Name is using options_id 1 and make sure that the Options Value is using the options_values_id of 9 ...

One method is to change one manually and then pull up all of the attributes for that products_id via phpMyAdmin to see the settings ...

Backup before running it ...

[howb]

Thanks Ajeh,

that worked a treat!

Rik