Re: Import tab delimited file to MySql
| From: | Mike Tuller | Date: | Thu, 10 Apr 2003 20:40:52 +0000 |
| Subject: | Re: Import tab delimited file to MySql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-143396@lists.php.net to get a copy of this message | ||
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?
On Thursday, April 10, 2003, at 03:38 PM, CPT John W. Holmes wrote:
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. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php