Re: Increasing an Integer field with SQL statement

2002-06-14 Thread 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 mat

Increasing an Integer field with SQL statement

2002-06-14 Thread Tab Alleman
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