From: Dan Nelson
Date: August 27 2002 6:24am
Subject: Re: ERROR 1062
List-Archive: http://lists.mysql.com/mysql/118039
Message-Id: <20020827062451.GE6858@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Aug 27), Osman Omar said:
> below is my tables properties, 
> and my last record id is 127;
> 
> mysql> desc emcs;
> +------------+-------------+------+-----+------------+----------------+
> | Field      | Type        | Null | Key | Default    | Extra          |
> +------------+-------------+------+-----+------------+----------------+
> | id         | tinyint(6)  |      | PRI | NULL       | auto_increment |


From the manual:

   `TINYINT[(M)] [UNSIGNED] [ZEROFILL]'
     A very small integer. The signed range is `-128' to `127'. The
     unsigned range is `0' to `255'.

What do you think happens with you hit 127?

Replace that TINYINT with INTEGER.

-- 
	Dan Nelson
	dnelson@stripped