RE: Import into mysql from csv-file
| From: | Jeremy Shovan | Date: | Tue, 18 Jan 2005 20:16:06 +0000 |
| Subject: | RE: Import into mysql from csv-file | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38216@lists.php.net to get a copy of this message | ||
Mysql> LOAD DATA INFILE '/tmp/jokes.txt' INTO TABLE jokes FIELDS
TERMINATED BY ''
http://dev.mysql.com/doc/mysql/en/mysqlimport.html
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
Jeremy Shovan
-----Original Message-----
From: Ruprecht Helms [mailto:rhelms@mayn.de]
Sent: Monday, January 17, 2005 6:32 AM
To: php-db@lists.php.net
Subject: Import into mysql from csv-file
Hi,
how do I import data stored in a csv-file (formated text) into a
mysql_database.
Regards,
Ruprecht