Re: MySQL Increment/Decrement

Ben Miller wrote:

I hope this isn't a bone-head question - Is there a MySQL query that will increment/decrement the value in an integer column with a single query - in other words, I don't have to run a SELECT query to get the value, add/subtract to/from the value, and then run an UPDATE query to store the new value?

You mean:

    UPDATE table SET column = column + 1;

? Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP