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
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 numbers. For
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]