Add INT value to a field?

Discussion in 'MySQL' started by coder11001, Dec 14, 2011.

0
  1. #1
    How would I add (or minus) and integer value of 1 to a field using a link?

    Please explain in amateur terms because I'm incredibly new to MYSQL

    Thanks very much! xx
     
    coder11001, Dec 14, 2011 IP
  2. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #2
    UPDATE mytable SET myfield = myfield + 1 WHERE anotherfield = somevalue;
     
    Rukbat, Dec 15, 2011 IP