Techblog

Tech Blog

Our latest geek adventures!

Posts Tagged ‘increment’

17 October Raise by one SQL statement

Posted by Gert-Jan in Databases

Today I discovered that it’s very easy to raise a value by one (or any other number) when you’re using a MySQL database. This is all:

UPDATE tablename SET value = value + 1 WHERE ...

No Comments - Tags: ,