List:General Discussion« Previous MessageNext Message »
From:Van Date:July 31 1999 2:22am
Subject:Re: does auto_increment have a limit
View as plain text  
Dave Reinhardt wrote:
> 
> I finaly got my data into the table, BUT now I can not figure out why it
> stops at 127 records out of 600
> 
> I do have the id numbers in the testTab.txt file like
> 1<tab>"fname"<tab> "mname" etc
> 
> mysql> describe testall
>     -> ;
> +-------+-------------+------+-----+---------+----------------+
> | Field | Type        | Null | Key | Default | Extra          |
> +-------+-------------+------+-----+---------+----------------+
> | id    | tinyint(6)  |      | PRI | 0       | auto_increment |
> | fname | varchar(16) |      |     |         |                |
> | mname | char(2)     |      |     |         |                |
> | lname | varchar(20) |      |     |         |                |
> | org   | varchar(50) |      |     |         |                |
> | email | varchar(40) |      |     |         |                |
> +-------+-------------+------+-----+---------+----------------+
> 6 rows in set (0.01 sec)
> 
> mysql> delete from testall;
> Query OK, 0 rows affected (0.01 sec)
> 
> mysql>  LOAD DATA INFILE '/var/tmp/testTAB.TXT' REPLACE INTO TABLE testall FIELDS
> TERMINATED BY '\t'
>     -> enclosed by '"'
>     -> lines terminated by '\n';
> Query OK, 1111 rows affected (0.39 sec)
> Records: 619  Deleted: 492  Skipped: 0  Warnings: 498
> 
> mysql> select * from testall;
>
> +-----+------------+-------+------------------+------------------------------------------+--------------------------------+
> | id  | fname      | mname | lname            | org                                  
>    | email                          |
>
> +-----+------------+-------+------------------+------------------------------------------+--------------------------------+
> |   1 | Jo Anne    |       | Smith             | National Corporation       |
> someone@stripped |
> |   2 | Jane       |       | Jones            | University of California             
>    |
> another@stripped     |
> ~~~~~~~~~~~~~~~~~~~~~
> records remove to save space
> ~~~~~~~~~~~~~~~~~~~~~
> | 126 | John  |       | Leon          | California State University  Los Angeles |
> cdesdon@stripped |
> | 127 |            |       |                  |                                      
>    |                                |
>
> +-----+------------+-------+------------------+------------------------------------------+--------------------------------+
> 127 rows in set (0.01 sec)
> 
> dave@stripped
> 
> SeaPortNetHosting: Reliable Web Hosting
> Plans from $17.95 www.yourname.com
> http://www.SeaPortNet.com/
> 1(800)953-2400 fax/VM Ext 2
> tel. 1(800)953-2400 fax/VM 1(209)551-0411
Dave,
Set your id field to an int.  It's not big enough to hold over 127. 
Hope that helps.
Van
-- 
=========================================================================
Linux rocks!!!   http://www.dedserius.com
=========================================================================
Thread
does auto_increment have a limitDave Reinhardt31 Jul
  • Re: does auto_increment have a limitVan31 Jul