Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    39

    Unanswered: Multiply all fields by 1.5

    Hi all!

    I need to increate all prices in a Products table by say 20%. I have tried various SQL queries like

    UPDATE Product_Price set Product_PRICE * 1.2

    or created a new field

    UPDATE Product_Price set Product_New_Price = Product_Price * 1.2

    but that doesn't seem to please the gods governing MySQL

    Good old days are gone where a simple dBaseIII statement like

    replace all Product_Price with Product_Price * 1.2 would solve it 10 secs

    Any idea anyone ?

    Thanks in advance

    John in sunny Brussels

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the table name in your UPDATE statement was missing

    UPDATE Products
    SET Product_Price = Product_Price * 1.2
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2004
    Posts
    39

    Cool Solved. Thanks

    Thank you! This was one of the - can't remember how many - variations I hadn't tried. Will know better next time.

    Have fun!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •