Techblog

Tech Blog

Our latest geek adventures!

17 October Raise by one SQL statement

Posted by Gert-Jan on 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 ...

Tags: ,

Leave a Reply