We need a simple script to import a large csv file
(about 3000-5000 rows and about 30-40 fields) into a table and then run some sql.
This needs to have error checking and handling. Email
notification with the some of the row information as well
as the mysql error message if certain rows fail to be inserted, and the ability to continue inserting even if one row fails.
A test CSV file will be provided, along with the table ddl and the sql to be executed after the import succeeds.