RE: [PHP] Upload a CSV file to MySQL

I'm not sure if you're talking just PHP, but this is the best database tool I've ever used: http://anse.de/mysqlfront/ /* Key-Features With MySQL-Front you can... create/drop databases create/drop tables edit/add/delete fields edit/insert/delete records edit BLOBs and MEMOs with Bitmap/GIF/JPEG-Support view a list of server-variables view and kill other user-processes execute (large) SQL-scripts view advanced table-properties, such as Type, Comment, Key_Length and so on export table-structure and data into SQL-scripts or other databases replicate databases between two hosts ("Export tables...") save data to CSV-Files (ideal for working with MS-Excel ®) or HTML-tables copy CSV-data/HTML-Tables to clipboard copy tables to new table-names manage users (new in 2.0: edit existing users) flush Host/Logs/Privileges/Tables write SQL-queries with syntax-highlighting import data from ODBC-datasources do table-diagnostics (check, optimize, repair, analyze) and a lot more... */ Dan -----Original Message----- From: Ben C. [mailto:benc@cox.net] Sent: Monday, March 04, 2002 11:30 AM To: php-general@lists.php.net Subject: [PHP] Upload a CSV file to MySQL Is there an easy way to upload a CSV file into a MySQL table? Is there also a way to export the MySQL file into a CSV file? I would like to make a form using PHP to do import a CSV file into an existing table. Any advise would be appreciated. Ben -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php