List:General Discussion« Previous MessageNext Message »
From:Philippe Poelvoorde Date:August 16 2005 2:03pm
Subject:Re: cast and numeric conversion
View as plain text  
Scott Noyes wrote:
>>I've got two columns, one is 'integer' (and store negative value), the
>>other one 'tinyint unsigned' (only > 1 stored in it), when I multiply
>>these columns, quantity with negative value does not show up.
>>(I expect -50*10 to give : -500, but the field stay blank.)
>>I've look a bit at the documentation, but can't find anything on type
>>promotion. Where can I find this ?
> 
> 
> http://dev.mysql.com/doc/mysql/en/cast-functions.html
> 

thank you ;)

-- 
Philippe Poelvoorde
COS Trading Ltd.
Thread
cast and numeric conversionPhilippe Poelvoorde16 Aug
  • Re: cast and numeric conversionScott Noyes16 Aug
    • Re: cast and numeric conversionPhilippe Poelvoorde16 Aug