An easy way to reset stock of all products to a certain number?

[tj1]

Does anyone know if there's an easy way for setting the quantity of all the products in my store to a certain number like 0 or 50, perhaps through an sql statement(not sure if that's what it's called)?

Thanks.

[swguy]

update products set products_quantity = 50;

It's always a good idea to make a backup before hitting your database with SQL commands. On the off chance that you sprout ten thumbs all of a sudden! :)

Good luck,
Scott

[tj1]

Thank you so much. :)