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
=========================================================================
