1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

sql query to add additional shipping cost

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

  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;
    SEMrush
     
    marksz, May 14, 2010 IP
    SEMrush
  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