John --
...and then Dillon, John said...
%
% Thanks for the three replies and two tickings-off. It was a spelling
% mistake in my table name.
I hate those :-) But I'm glad to see you found your answer.
%
% The reason I tend to top post is that you then don't have to read the
% disclaimer or
Thanks for the three replies and two tickings-off. It was a spelling
mistake in my table name.
The reason I tend to top post is that you then don't have to read the
disclaimer or address details from my company in a reply. Sometimes in easy
situations the question is clear from the reply plus th
UPDATE fieldname SET fieldname=fieldname+1 WHERE where condition
Make sure to have a WHERE condition, or you will update all the 'fieldname'
entries in your table - you have been warned.
PS - Didn't look very hard on mysql.com, did you ;-p
PPS - Please can you stop posting 40 empty lines to the
In article
<[EMAIL PROTECTED]>
, [EMAIL PROTECTED] says...
> 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 www.mysql.com
> manual. Seems it only deals with SELECT and WHERE.
>
> Thanks,
>
> John
UPDATE