MySQL makes it nice and easy to load the CSV files in. First create a table as follows:
drop table if exists matches;
create table matches ( matchdate date not null,
hometeam varchar(25) not null,
homescore smallint not null,
awayteam varchar(25) not null,
awayscore smallint not null
create index id_matches on matches( matchdate, hometeam, awayteam);
It is then easy to load the date in using the load data command:
LOAD DATA LOCAL INFILE
into table rsssf.matches
fields terminated by ','
ignore 8 lines
( matchdate, hometeam, homescore, awayteam, awayscore );
It is then straightforward to perform simple queries on the database. For example all the home derbies for Liverpool:
select matchdate, hometeam, homescore, awayscore, awayteam
where hometeam = "Liverpool" and awayteam = "Everton"
order by 1;
gives the result at the top of this post.