Instead of writing a script to pull in information from a CSV file, you can link MYSQL directly to it and upload the information using the following SQL syntax. To import an Excel file into MySQL, first export it as a CSV file. Remove the CSV headers from the generated CSV file along with empty data that Excel may have put at the end of the CSV …

MySQL - Import CSV.sql

# Create Table
CREATE TABLE IF NOT EXISTS `foo_table` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`bar_column` varchar(10) NOT NULL, 
`bat_column` varchar(10) NOT NULL, 
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

# Load Data
load data local infile '/path/to/file.csv' into table `foo_table` 
fields 
terminated by ','
enclosed by '"'
lines terminated by '\n'
(`bar_column`, `bat_column`);