Jump to content


Photo

How to add number to MySQL column??


  • Please log in to reply
1 reply to this topic

#1 techiefreak05

techiefreak05
  • Members
  • PipPipPip
  • Advanced Member
  • 494 posts
  • LocationER, MN

Posted 22 August 2006 - 04:42 PM

I have a column in my SQL DB, called zypoints ... how do i ADD to the current value.. lets say you have 5, and you do something where i want it to add 2 to that 5, to make 7, how would i do that?


Link shortener with advanced, detailed statistics:

http://tyny.us/

#2 hitman6003

hitman6003
  • Members
  • PipPipPip
  • Advanced Member
  • 1,807 posts

Posted 22 August 2006 - 04:47 PM

UPDATE table SET column = column + 5 WHERE id = '$id';





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users