transfering CSV data to MySQL

[Anon]

Hello - I wanted to ask if anyone has written or knows of any little php programs that parse CSV data into a MySQL dump file and re-arrange any values into their appropriate position. I know this is a very common task, and I thought I'd ask first before writing my own hack. Any help is geatly appreciated.

Thanks in advance!

Aaron

[Anon]

You might just want to try MySQL's "LOAD DATA..." SQL statement first since it is built in to MySQL. You can specify which columns (and the order) you want to insert into a table as well, so you shouldn't need to rearrange your CSV file.

[Anon]

Thank you! LOAD DATA works great!!

Aaron