[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: does auto_increment have a limit
From:       Van <vanboers () server ! dedserius ! com>
Date:       1999-07-31 2:22:59
[Download RAW message or body]

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@xxx.com |
> > 2 | Jane       |       | Jones            | University of California              \
> > |
> another@xxx.com     |
> ~~~~~~~~~~~~~~~~~~~~~
> records remove to save space
> ~~~~~~~~~~~~~~~~~~~~~
> > 126 | John  |       | Leon          | California State University  Los Angeles |
> cdesdon@xxx.com |
> > 127 |            |       |                  |                                     \
> > |                                |
> +-----+------------+-------+------------------+------------------------------------------+--------------------------------+
>  127 rows in set (0.01 sec)
> 
> dave@SeaPortNet.com
> 
> 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
=========================================================================

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread8963@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@lists.mysql.com instead.


[prev in list] [next in list] [prev in thread] [next in thread]