drop database if exists superbowldb;
create database if not exists superbowldb;
use superbowldb;

create table superbowl(
    bowlNumber int(3) primary key auto_increment,
	date year,
	winningTeam char(50),
	losingTeam char(50),
	winningScore int(3),
	losingScore int(3),
	venue char(50),
	city char(50),
	state char(50)
);

show columns from superbowl;


Load data infile "D:/data.txt"
INTO table superbowl (bowlNumber, date, winningTeam, losingTeam, winningScore, losingScore, venue, city, state);

select * from superbowl;