How to increase quantity of all products to 10

[Benjjj6]

Hi

 

I'm hoping someone can write a short SQL query that will change the quantity of all products in my shop to 10. Is this possible to do? Currently all products have a quantity of 0.

 

Let me know if you need more info...

 

 

Thanks,

 

Ben

[♥Vger]

UPDATE products SET products_quantity='10';

 

Always BACKUP the db BEFORE running sql commands.

 

Vger

[Benjjj6]

Thankyou Vger, that worked perfectly :)

[♥Vger]

You're welcome. That wasn't a difficult one - even for me, and I'm no SQL genius.

 

Vger