List:General Discussion« Previous MessageNext Message »
From:Micheal Mc Evoy Date:March 11 1999 9:21pm
Subject:Re: AUTO_INCREMENT Limits to 256 records
View as plain text  
On Thu, 11 Mar 1999, Kevin P. O'Brien wrote:

>Date: Thu, 11 Mar 1999 12:57:39 
>From: Kevin P. O'Brien <kevino@stripped>
>To: "mysql@stripped" <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 <kevino@stripped>
>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.

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