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@xxxxxxx] Sent: Monday, January 17, 2005 6:32 AM To: php-db@xxxxxxxxxxxxx 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php