Latest News: (loading..)

Archived

This topic is now archived and is closed to further replies.

stevegos

bulk price increase using sql

2 posts in this topic

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites