In article 
> Can I UPDATE an int record with MySql and add 1 to it? without extracting it
> into a variable first?  If so, what am I looking for in the
> manual.  Seems it only deals with SELECT and WHERE.
> Thanks,
> John

UPDATE table SET field = field + 1 WHERE 1 (or something very like that) 
should work.

BTW did you know your mailer adds a swag of blank lines before the 

Quod subigo farinam

A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet?

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to