Originally Posted by
RetailProductsGroup
Using the "SQL Query Executor" I need the lines necessary for the following:
changing all prices from $2.96 to $2.99 (not a percentage increase)
and changing all stock level quantities to 100 pieces (or whatever i will need).
Code:
UPDATE `products` SET `products_price` = 2.99 where `products_price` = 2.96 ;
Code:
UPDATE `products` SET `products_quantity`= 100 WHERE 1 ;
Usual caveats apply. Use at your own risk. Make backups first.
Cheers
Rod
ps "WHERE 1" effectively means "match all"
Bookmarks