create database fechell;

use fechell;

create table transactions (contribution_date date,contribution_amount int, zipcode char(5)) engine 'MyISAM';

load data local infile 'obama-data-F3P-2007-2008.csv' into table transactions fields terminated by ',' lines terminated by '\r\n' ignore 1 lines (contribution_date,contribution_amount,zipcode);

ALTER TABLE transactions ADD INDEX  ix_zipcode (zipcode);