From: Micheal Mc Evoy Date: March 11 1999 9:21pm Subject: Re: AUTO_INCREMENT Limits to 256 records List-Archive: http://lists.mysql.com/mysql/48 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Thu, 11 Mar 1999, Kevin P. O'Brien wrote: >Date: Thu, 11 Mar 1999 12:57:39 >From: Kevin P. O'Brien >To: "mysql@stripped" >Subject: AUTO_INCREMENT Limits to 256 records > >I would like to know if anyone has a solution to this anomaly. > >I am seeting up a DB with an auto_increment field. > >I have tried all of the INT Types. > >It seems that when I go to load the data it will only accept 256 records. > >What am I missing? > >Thanks, > > > >Kevin P. O'Brien, MCP, CPST >Systems Administration >Irenyx Data Group, Inc. >(Office) 1.250.334.9641 ext.239 >(Fax) 1.250.334.2365 >(Pager) 1.888.805.3820 >(Toll Free) 1.800.275.4260 ext.239 > > >PGP Public Key Fingerprint: 56C4 2F8C 5731 08C1 684D 05DC 05E5 697F > Have you tried using BIGINT ? That's what I use and I'm running over 50,000 Micheal --- Micheal Mc Evoy mjmc@stripped http://www.whitepine.com WhitePine Consulting supports the Free Software Foundation and it ideals by promoting, using and supporting Open Source, GNU and GPL'd Software.