On Tuesday 04 March 2003 19:35, Jamie Jennings wrote:
> Yes that must be it. Both columns are unsigned. Is
> there any way to accomplish this with one query with
> unsigned columns?
Take a look at cast functions:
http://www.mysql.com/doc/en/Cast_Functions.html
> Otherwise I will have to
Yes that must be it. Both columns are unsigned. Is
there any way to accomplish this with one query with
unsigned columns?
Otherwise I will have to fetch each column seperately
(two queries) and then do the subtraction outside
MySQL (in my C code).
--- Victoria Reznichenko
<[EMAIL PROTECTED]> wr
On Tuesday 04 March 2003 16:51, Jamie Jennings wrote:
> Hi. I've got two mediumint columns in a mysql table,
> and I'm trying to subtract them like this:
>
> SELECT column1-column2 FROM table WHERE
> name='johndoe';
>
> This works some of the time, however, I get weird
> results for negative numbe
Hi. I've got two mediumint columns in a mysql table,
and I'm trying to subtract them like this:
SELECT column1-column2 FROM table WHERE
name='johndoe';
This works some of the time, however, I get weird
results for negative numbers. For example, when
column1=0 and column2=4995, I get:
18446744073
