dadamssg Posted April 5, 2009 Share Posted April 5, 2009 if i have a int() field in my db...is there a mysql way to update it by adding one? i want to count how many times a user replies on a forum...i know i can query their username and pull out that number then add one to it, then replace the old one with the new one...but is there a mysql function that does this? Quote Link to comment Share on other sites More sharing options...
Maq Posted April 5, 2009 Share Posted April 5, 2009 There's not need for a function to do this. Just update the column by adding 1 to it. Quote Link to comment Share on other sites More sharing options...
dadamssg Posted April 5, 2009 Author Share Posted April 5, 2009 how would i do that?...is what im asking Quote Link to comment Share on other sites More sharing options...
corbin Posted April 6, 2009 Share Posted April 6, 2009 UPDATE table1 SET column1 = column1+1; Quote Link to comment Share on other sites More sharing options...
aschk Posted April 6, 2009 Share Posted April 6, 2009 p.s. make sure to add a WHERE clause because Corbin's SQL statement will update EVERY row in your table... WHOOPS! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.