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.
