Incrementing in MySQL

[Jules00]

Hey,

Im needing a script that will increment a value stored in a MySQL database. Currently, I retrieve the value from the database with php, increment it, then send it back to the database. I was just wondering if there is an easier way to do this. Is there some way to tell MySQL to increment a stored value.

Thanks! 🙂

[ir4z0r]

UPDATE table SET col=col+1 WHERE ...

should do the trick