sql query to add additional shipping cost

Discussion in 'Databases' started by marksz, May 14, 2010.

0
  1. #1
    I need help in a sql query to add additional shipping cost of $2 in addition to 10% increase in price for following formula

    UPDATE myproducts SET price = price*1.1;
     
    marksz, May 14, 2010 IP
  2. 50plus

    50plus Guest

    Messages:
    234
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Have you tried :

    UPDATE myproducts SET price = price*1.1+2;
     
    50plus, May 14, 2010 IP