[thelist] Increasing an Integer field with SQL statement

Tab Alleman Tab.Alleman at realmetros.com
Fri Jun 14 16:28:01 CDT 2002


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?

TIA
Tab



More information about the thelist mailing list