Re: Import tab delimited file to MySql
| From: | CPT John W. Holmes | Date: | Thu, 10 Apr 2003 20:59:08 +0000 |
| Subject: | Re: Import tab delimited file to MySql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-143398@lists.php.net to get a copy of this message | ||
> >> I am wanting to create a script that I can use to import a tab
> >> delimited file and populate a MySql table. I am not sure how to go
> >> about this. I know I should use LOAD DATA, but any advice beyond that
> >> would be helpful.
> >
> > This should be asked on a MySQL list or board. You just need to learn
> > the
> > proper syntax of the LOAD DATA query and it'll do what you want.
>
> It's not the syntax, I am not sure you read the file and then load, or
> you save the file to the server then read. What is best?
The file needs to be on the server. You give the path to it in the SQL
query. If you're going to involve PHP in this for anything, it's just
uploading the file to the server possibly.
---John Holmes...