mySQL and subtracing .5

[Nigel]

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

[Pedro Graca]

Re: mySQL and subtracing .5

Nigel wrote:[color=blue]
> 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[/color]

What query? ???

mysql> select id-0.5 from foobar where id<3;
+--------+
| id-0.5 |
+--------+
| 0.5 |
| 1.5 |
+--------+
2 rows in set (0.00 sec)
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

[Tony Marston]

Re: mySQL and subtracing .5

Integers by their very definition are whole numbers, therefore decimal
places cannot be used. If you want decimal places then change the field type
to FLOAT, REAL, DECIMAL or NUMERIC.

--
Tony Marston

http://www.tonymarston.net

"Nigel" <nobody@here.co m> wrote in message
news:c1qqvg$qoq $1$8302bc10@new s.demon.co.uk.. .[color=blue]
> 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[/color]
the[color=blue]
> query
>
>
>[/color]