List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 14 2002 9:39pm
Subject:Re: Increasing an Integer field with SQL statement
View as plain text  
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

Thread
Increasing an Integer field with SQL statementTab Alleman14 Jun
  • Re: Increasing an Integer field with SQL statementVictoria Reznichenko18 Jun
Re: Increasing an Integer field with SQL statementPaul DuBois14 Jun