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