On Monday 20 January 2003 08:22, Octavian Rasnita wrote:
> But I don't want to perform a 15 - id, meaning 15 - 10.
> I want to calculate 5 - id, meaning 5 - 10.
>
> It should give me -5 or 5 but not | 18446744073709551611 |
The result of the above expression is UNSIGNED, because column 'id' is INT
AIL PROTECTED]>
To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>; "Brian
Lindner" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, January 20, 2003 08:22
Subject: Re: Substraction
> But I don't want to perform a 15 - i
Connect (Berlin)" <[EMAIL PROTECTED]>
To: "Brian Lindner" <[EMAIL PROTECTED]>; "Octavian Rasnita"
<[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, January 20, 2003 1:09 AM
Subject: Re: Substraction
Brian,
> > create
"MySQL" <[EMAIL PROTECTED]>
Sent: Monday, January 20, 2003 01:09
Subject: Re: Substraction
> Brian,
>
> > > create table test(id int unsigned);
> > > insert into test values(10);
> > > select 15 - id from test;
> > > The result is 18446744073
ian Lindner" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Sunday, January 19, 2003 10:28 PM
Subject: Re: Substraction
> Octavian,
>
> Sunday, January 19, 2003, 7:31:57 AM, you wrote:
> >
Octavian,
Sunday, January 19, 2003, 7:31:57 AM, you wrote:
> Hi all,
> I've tried the following query:
> create table test(id int unsigned);
> insert into test values(10);
> select 15 - id from test;
> The result is 18446744073709551611 instead of -5.
I ran this.. and it worked for me
MySql 4
