CodingForums.com - View Single Post - Native Integer Incrementing (Existing Value)

Old Pedant · 11-16-2012, 01:19 AM

And of course you can increment a field as shown there.

You can do a lot more than that:

Code:

UPDATE sometable SET field1 = field1 + 1 + IF(field2 > 3, 7, -12 )
WHERE id = 9102 AND field1 < 1000000

and so on and so on.

Heck, you can even "tack on" to text fields:

Code:

UPDATE sometable SET ticks = CONCAT( ticks,'*') WHERE id = 1817

That would make the ticks field grow by one "*" every time the UPDATE is executed.

11-16-2012, 01:19 AM	PM User \| #8
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,210 Thanks: 59 Thanked 3,996 Times in 3,965 Posts	And of course you can increment a field as shown there. You can do a lot more than that: Code: UPDATE sometable SET field1 = field1 + 1 + IF(field2 > 3, 7, -12 ) WHERE id = 9102 AND field1 < 1000000 and so on and so on. Heck, you can even "tack on" to text fields: Code: UPDATE sometable SET ticks = CONCAT( ticks,'') WHERE id = 1817 That would make the ticks* field grow by one "*" every time the UPDATE is executed. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.