Hi Dr, try:
LOAD DATA INFILE "myfile.csv" INTO TABLE mytable FIELDS TERMINATED BY "," LINES TERMINATED BY "\r\n" ; of course, the structure of your CSV file must match exactly that of your table. hth ----- Original Message ----- From: "Dr. Indera" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 04, 2002 6:20 AM Subject: [PHP-DB] Upload csv file into mysql > Hello, > > Is there a way to upload data in a csv file into a mysql table? > > Thanks > Indera > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php