Re: Increasing an Integer field with SQL statement

[Paul DuBois]

At 17:29 -0400 6/14/02, Tab Alleman wrote:
>Hi, can I do a sql query in MySQL that would do something like this:
>
>UPDATE table SET SomeInteger=SomeInteger+1 WHERE (Some Condition)
>
>I know that this exact syntax doesn't work, but is there a way to do
>what I'm trying to do, which is to do a math function on an integer in
>the table with a SQL command?

What happened when you tried it?

>
>TIA
>Tab