This is a small tip which can help you optimize your MySQL query. Since you do not have to first “read” the record, instead you can increment it right there. I have seen some newbies doing the read and then increment process, which uselessly increases a select query to the database, each time you have to update a certain record.
This is sleek way to increment or decrement a record, of course the integer value 🙂
Let us suppose I need to increment the visitors count on my website in a table, this is how I can write the increment query –
Update visitors set visits=visits+1;
And if you want to decrease a record just change + to – , simple arithmetic ?
Hope that this simple, newbie trick helps you in some way.
Stay Digified !!