CREATE TABLE hw2_state_identifier (
	id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
	country INT(11) NOT NULL,
	value VARCHAR(255) NOT NULL,
	display_name VARCHAR(255) NOT NULL
);

LOAD DATA INFILE '/tmp/states.csv'
INTO TABLE hw2_state_identifier
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(id, country, value, display_name)