Re: mysql load data form input file
| From: | B.A.T. Svensson | Date: | Sat, 02 Jul 2005 15:37:50 +0000 |
| Subject: | Re: mysql load data form input file | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39847@lists.php.net to get a copy of this message | ||
On Thu, June 30, 2005 9:05 pm, blackwater dev said:
> Does anyone know if it is possible to load data into multiple
> tables using one file when you use load data local infile?
That is not possible.
> I need to load several tables but don't want to have tons of files.
You may need to change your design for this - if possible. To address
"if possible" some few question need some answers first;
Why do you have "tons of files / What creates all these files?
Why do they need to be loaded in diffrent tables?
How often does this happen?