List:General Discussion« Previous MessageNext Message »
From:Robert Hazeltine Date:March 11 1999 9:41pm
Subject:Re: AUTO_INCREMENT Limits to 256 records
View as plain text  
Kevin

On Thu, 11 Mar 1999, Kevin P. O'Brien wrote:

> Well, I tried your entry and received the following error
> 
> ERROR 1062 at line 291: Duplicate entry '256' for key 1
> 
> ....Still thinking. Maybe it was restricted while installing Mysql.

I had the same problem with one of my tables.  It was fixed when I changed
the numeric type.  256 sounds right for int.

Rob...
Robert Hazeltine                      Member of UWSN Web Management Group
Project Officer (Web Development)     Phone:  +61 (2) 4736 0218
Central Administration                Email:  r.hazeltine@stripped
University of Western Sydney, Nepean  http://www.nepean.uws.edu.au/

Thread
AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsMicheal Mc Evoy11 Mar
  • one query for two identical tablesTao Liang3 Mar
    • RE: one query for two identical tablesNicolas Prade3 Mar
  • group by conditionsTao Liang5 Mar
    • Re: group by conditionssinisa6 Mar
      • accessing db while updating itTao Liang26 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsRobert Hazeltine11 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • select count distinctChinaConnect11 Mar
    • Re: select count distinctChris12 Mar
    • Re: select count distinctScott Liu13 Mar
      • Re: select count distinctMichael Widenius15 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsChristian Mack12 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
Re: AUTO_INCREMENT Limits to 256 recordsEd Carp12 Mar
Re: AUTO_INCREMENT Limits to 256 recordsEd Carp13 Mar
Re: Bad handshake problem with java and MySQL 3.22.32Carlos Proal15 Feb