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: 18446744073709546621 when really the answer should be -4995. What am I doing wrong? Thanks! ______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
