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 <condition>


or will I have to so the A-B calculation in my application code instead?

Also can I use

select C from X where <condition>
 Then 

update X set C = (return values got from above + New Increment)
where <condition>

Any help would be greatly appreciated

many thanks

Joe



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to