Re: from a textfile/textarea to a mysql INSERT
| From: | John W. Holmes | Date: | Sun, 22 Jun 2003 03:30:15 +0000 |
| Subject: | Re: from a textfile/textarea to a mysql INSERT | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-152422@lists.php.net to get a copy of this message | ||
Øystein Håland wrote:
Use the LOAD DATA INFILE command to load the entire file at once. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ PHP|Architect: A magazine for PHP Professionals – www.phparch.comFrom Excel you can save a table as a tab separated txt-file. I want to takethis and execute INSERT queries (by uploading the file or by copying the content into a textarea). Anyone who has a script to do this? My platform is Windows, but the script will be used on a Linux web server.