MySql changes

[OSVS]

Ok - I finally figured out most of my shipping problems. What I need to do now is make all items 1lb. I have most already set, but is there a way to go into MySql thru PHPMA and change them all at one?

 

I've made the product weight default at 1, but it doesn't seem to work right. If someone knows of a way to do this, please let me know. All I need to do is change what is in the DB now, all new items I will add the weight when entering them in.

 

Presently I have over 500 products, so manually changing each of them is time consuming.

 

Phillip

[TomThumb]

update products set `products_weight` = 1 where 1;

[Nacer]

For more info see:

 

http://dev.mysql.com/doc/mysql/en/update.html

 

Nacer.

[OSVS]

Thanks very much guys - now if I can only fix it so the page isn't all black when browsing with a Mac :)

 

Thanks again