Sql help please

[jewelrylady]

what is sql code to change all my quantities to 100?

thanks.

[Ajeh]

Is this for all products? Some products? Every other product? Could you be a tad more vague?

[jewelrylady]

what is sql code to change all my quantities to 100?

Yes all products.

[Ajeh]

You could use this in the Tools ... Install SQL Patches ...

UPDATE products SET products_quantity = 100; 

This will change the products_quantity on every single Product in your shop to be 100 ...

NOTE: backing up your database is always a good plan before doing things like this ...

[jewelrylady]

worked perfectly! Thank you.