mySQL and subtracing .5

From: Nigel (nobody_at_here.com)
Date: 02/28/04 

Date: Sat, 28 Feb 2004 19:42:41 -0000

I have a number in a INT field in a table and I want to subtract .5 (1/2)
from the number... ie 4-.5=3.5

I have tried it in mysql but it does seem to work, can anyone help with the
query

Relevant Pages

  • Query
    ... Google's Group Search does not return any MySQL groups....go figure. ... What I want to do, is for customer_count, I want to subtract the value ... from the previous value and get the result in the query. ... I want to subtract Jane Doe from John Doe and get the result in the ...
    (comp.lang.php)
  • Re: New comer to reports
    ... I want the query &/or the report to pull the "Op Bal" from the products table & then add or subtract what I ... Then the next entry is a different product ID. ... Two entries later we send out 3 units of 250 pcs. ...
    (microsoft.public.access.reports)
  • Re: Percent on sum total
    ... Thank you since your first suggestion in placing the expression in query ... create the expression if we need to subtract 6 percent from the country china ... Could this be a field in query not allowing for the calculation ... Add to your report to the right of your InvAmt ...
    (microsoft.public.access.reports)
  • Re: what is wrong with this statement
    ... The dash sign means "subtract the value on the right from the value on ... UPDATE is a Reserved word, and Reserved words should not be used to ... characters and the underscore character), or one may put brackets around the ... 2-I have not been able to figure out how I can do thsi query by typing ...
    (comp.databases.ms-access)
  • Re: Using database fields in a calculation
    ... You could also return this in your query ... SELECT Qtyonhand, Qtycommitsales, Qtyonhand-Qtycommitsales AS Qtybalance ... > I need to use some database fields for calculations but I an not certain ... For example I want the Onhand value to subtract the ...
    (microsoft.public.inetserver.asp.db)