load data infile
| From: | Hull, Douglas D | Date: | Fri, 16 Jul 2004 18:18:21 +0000 |
| Subject: | load data infile | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-190737@lists.php.net to get a copy of this message | ||
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.
Any ideas, if you could email me directly I would appreciate it, thanks,
Doug