Re: operators in mysql

2004-03-23 Thread Alec . Cawley
"joe collins" <[EMAIL PROTECTED]> wrote on 23/03/2004 14:33:13: > can operators be used in MySQL e.g. > > a table Table X with column A, column B column C > > All three are floats > > can I use > > select (A-B) > from X > where > > > or will I have to so the A-B calculation in my applicat

operators in mysql

2004-03-23 Thread joe collins
Hi, can operators be used in MySQL e.g. a table Table X with column A, column B column C All three are floats can I use select (A-B) from X where or will I have to so the A-B calculation in my application code instead? Also can I use select C from X where Then update X set C = (ret