1000,900,Johnson Field,5,Chi Bandits
2000,1200,Marc Field,2,Raiders
3000,900,Holy Field,3,Saints
4000,1000,Y High,4,Barbarians




INSERT INTO Team (tid, dues, field, trank, name) values ('5000',900,'Johnson Field',5,'Chi Bandits');




LOAD DATA INFILE "e:/teams.txt"
INTO TABLE team
COLUMNS TERMINATED BY ','
LINES TERMINATED BY '\n'
;