Re: from a textfile/textarea to a mysql INSERT
| From: | �ystein H�land | Date: | Sun, 22 Jun 2003 12:31:44 +0000 |
| Subject: | Re: from a textfile/textarea to a mysql INSERT | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-152444@lists.php.net to get a copy of this message | ||
"John W. Holmes" <holmes072000@charter.net> skrev i meddelandet
news:3EF522C7.6020909@charter.net...
> Øystein Håland wrote:
> >>From Excel you can save a table as a tab separated txt-file. I want to
take
> > this 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.
>
> Use the LOAD DATA INFILE command to load the entire file at once.
Thanks (and I'm working on it right now). But what about the textarea way?