From: Dan Nelson
Date: December 15 2003 2:48am
Subject: Re: integer not being inserted correctly
List-Archive: http://lists.mysql.com/mysql/155676
Message-Id: <20031215024853.GF17799@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Dec 14), A Pasetti said:
> When attempting to insert an integer into an integer column, a
> different value is being inserted for the given row. Check out the
> sql below to see what I mean. The integer 7819359281 is somehow
> changed to 2147483647 when it's inserted.
> 
> Perhaps someone has experienced this problem and could suggest a fix.
> I'm using MySQL 4.0.

Use a larger numeric type.  

http://www.mysql.com/doc/en/Numeric_types.html

Type      Bytes     From                 To

TINYINT   1         -128                 127
SMALLINT  2         -32768               32767
MEDIUMINT 3         -8388608             8388607
INT       4         -2147483648          2147483647
BIGINT    8         -9223372036854775808 9223372036854775807
 
-- 
	Dan Nelson
	dnelson@stripped