1 reply to this topic

[stevegos]

Hi

I have a shop selling alcohol products and here in the UK, there is a tax duty price increase on all bottles of 0.15 (15 pence)

So using phpmyadmin (and my limited sql knowledge) I think I can use the following sql to bulk increase the prices across the entire database:

UPDATE 'products' SET 'products_price' = products_price+0.15;

will this work?

Thanks, Steven

Edited by stevegos, 19 April 2011 - 12:20 PM.

[stevegos]

Hi

no-one replied so I backup the db and gave it try. Worked fine!

I did find that my original syntax wasn;t quite right. I had to remove the single quotes and the semi-colon on the end:

UPDATE products SET products_price = products_price+0.15

Steve