RE: [PHP] load data infile
| From: | Jay Blanchard | Date: | Fri, 16 Jul 2004 18:41:19 +0000 |
| Subject: | RE: [PHP] load data infile | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-190740@lists.php.net to get a copy of this message | ||
[snip]
I have a tab delimited file I am trying to load in my database using:
LOAD DATA INFILE '/users/dbs/sites/phpmyadmin/gus/exptab.txt' INTO TABLE
datable;
But all it will load is the first record and I have about 2000 records.
There are 20 columns of data in my 'exptab.txt' file I am loading and
there are 20 fields in datable.
[/snip]
Have you, by any chance, consulted the MySQL list?
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
?