List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 27 2002 6:24am
Subject:Re: ERROR 1062
View as plain text  
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
Thread
ERROR 1062Osman Omar27 Aug
  • Re: ERROR 1062Karthik27 Aug
    • Re: ERROR 1062Osman Omar27 Aug
      • Re: ERROR 1062Dan Nelson27 Aug
        • Re: ERROR 1062Osman Omar27 Aug