RE: [PHP] Re-Importing .CSV file into Database
| From: | Rick Emery | Date: | Tue, 12 Feb 2002 18:09:54 +0000 |
| Subject: | RE: [PHP] Re-Importing .CSV file into Database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-84410@lists.php.net to get a copy of this message | ||
look at MYSQL's LOAD DATA INFILE command:
LOAD DATA INFILE "datafile.csv" INTO mytable FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
-----Original Message-----
From: Thomas Edison Jr. [mailto:thomasedisonjr@yahoo.com]
Sent: Tuesday, February 12, 2002 12:02 PM
To: php-general@lists.php.net
Subject: [PHP] Re-Importing .CSV file into Database
Glory!
I have a bunch of .CSV (Microsoft Excel Comma
Seperated Values) Files with me, whose data i want to
put back into my mySQL database tables. How can i do
that through php? or otherwise...
thanks,
T. Edison jr.
=====
Rahul S. Johari (Director)
******************************************
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : abraxastech@yahoo.com
Tel : 91-4546512/4522124
*******************************************
__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php