| PCGear |
05-03-2004 09:04 PM |
Quote:
Originally Posted by shan
heres a simple way to update a column in your database by 10%
Code:
UPDATE xcart_pricing SET price=price/100, price=price*110;
backup your database before you run this if you dont trust it
The first bit divides your price by 100 which will give you 1%
The next bit times it by 110 which gives you your original + 10% :wink:
|
Would
Code:
UPDATE xcart_pricing SET price=price/100, price=price*112.5;
add 12.5% ? |
| B00MER |
05-03-2004 09:28 PM |
|
| All times are GMT -8. The time now is 01:39 PM. |
|
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
