[Valentina] [OFF] Decimal field in mySQL

[Frank Schima]

Hi Ruslan,


--- Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> Anybody have use Decimal field in mySQL ?
> 
> I wonder, because by sources, it looks like they do not have implemented
> arithmetic for decimals ???
> 
> You should be able easy check this:
> 
> Make table with f1 and f2 decimal fields.
> Make one records { 3.4  4.8 }
> 
> Now do 
> 
>     SELECT f1 + f2 FROM T
> 
> By sources I see that result will be 7.
> 
> Can anybody check this and confirm ?

Yes, this works in MySQL. 


-Frank


=====
Frank Schima                <mailto:frank at labrecyclers.com>
Lab Recyclers Inc.          <http://www.labrecyclers.com/>
Gaithersburg, MD USA        <http://www.ci.gaithersburg.md.us/>

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com