List:General Discussion« Previous MessageNext Message »
From:Osman Omar Date:August 27 2002 6:38am
Subject:Re: ERROR 1062
View as plain text  
It's work

thanks


On Tue, 2002-08-27 at 14:24, Dan Nelson wrote:
> 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