/* drop table if exists UFO; */
drop table if exists EDUCATION;

/* create table UFO
(
	date			varchar(24),
	shape			varchar(16),
	location		varchar(32),
	state			varchar(2),
	country			varchar(24)	DEFAULT 'None',
	source 			varchar(8),
	isUSA			varchar(1)
);
*/
create table EDUCATION
(
	ranking		int(2),
	state		varchar(32),
	college		int(2),
	general		int(2)
);


/* load data local infile'ufo.csv'
into table M.UFO
fields terminated by','; */

load data local infile'education.csv'
into table M.EDUCATION
fields terminated by',';