SQL query to set all products quantity to 1

I've just entered hundreds of items withouth setting their stock. Sincer I want them to allways be in stock I need to set the quantity for each product to 1. Since it's much easier then doing it 1 by 1, how can I do this with sql command?

skynetslo:

I've just entered hundreds of items withouth setting their stock. Sincer I want them to allways be in stock I need to set the quantity for each product to 1. Since it's much easier then doing it 1 by 1, how can I do this with sql command?

update zen_products set products_quantity = 1 WHERE 1 ;

You may need to change " zen_products" if your database uses a different prefix.

If SOME of your products already have quantities, a better command would be

update zen_products set products_quantity = 1 WHERE products_quantity = 0 ;

Cheers
Rod

Thank you very much RodG!

But be sure to turn off Admin->Configuration->Stock->Subtract stock to false.