Football teams SQL Database Dump for MySQL, Microsoft Access and Oracle

Preview
CREATE TABLE IF NOT EXISTS `teams` (
  `team_id` int(11) NOT NULL AUTO_INCREMENT,
  `team_name` varchar(255) NOT NULL,
  `team_nickname` varchar(255) NOT NULL,
  `team_stadium` varchar(255) NOT NULL,
  `team_stadium_capacity` int(11) NOT NULL,
  `team_stat` int(2) NOT NULL,
  `team_link` varchar(255) NOT NULL,
  `league_id` int(11) NOT NULL,
  PRIMARY KEY (`team_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=128 ;


INSERT INTO `teams` (`team_id`, `team_name`, `team_nickname`, `team_stadium`, `team_stadium_capacity`, `team_stat`, `team_link`, `league_id`) VALUES
(1, 'Manchester City', 'City', 'City of Manchester Stadium', 47726, 92, 'http://en.wikipedia.org/wiki/Manchester_City', 1),
(2, 'Bolton Wanderers', 'The Trotters', 'Reebok Stadium', 28101, 82, 'http://en.wikipedia.org/wiki/Bolton_Wanderers', 1),
(3, 'Manchester United', 'The Red Devils', 'Old Trafford', 75957, 91, 'http://en.wikipedia.org/wiki/Manchester_United', 1),
(4, 'Wolves', 'Wolves', 'Molineux Stadium', 29195, 80, 'http://en.wikipedia.org/wiki/Wolverhampton_Wanderers', 1),
(5, 'Liverpool', 'The Reds', 'Anfield', 45276, 89, 'http://en.wikipedia.org/wiki/Liverpool_FC', 1),
(6, 'Sunderland', 'The Black Cats', 'Stadium of Light', 49000, 82, 'http://en.wikipedia.org/wiki/Sunderland_FC', 1),
(7, 'Wigan Athletic', 'The Latics', 'DW Stadium', 25138, 81, 'http://en.wikipedia.org/wiki/Wigan_Athletic', 1),
(8, 'Norwich City', 'The Canaries', 'Carrow Road', 27033, 80, 'http://en.wikipedia.org/wiki/Norwich_City', 1),
(9, 'Newcastle United', 'The Toon', 'St James'' Park', 52387, 84, 'http://en.wikipedia.org/wiki/Newcastle_United', 1),
(10, 'Fulham', 'The Cottagers', 'Craven Cottage', 25700, 82, 'http://en.wikipedia.org/wiki/Fulham_FC', 1),
(11, 'Arsenal', 'The Gunners', 'Emirates Stadium', 60355, 87, 'http://en.wikipedia.org/wiki/Arsenal_FC', 1),
(12, 'Chelsea', 'The Pensioners', 'Stamford Bridge', 41841, 90, 'http://en.wikipedia.org/wiki/Chelsea_FC', 1),
(13, 'Stoke City', 'The Potters', 'Britannia Stadium', 28384, 85, 'http://en.wikipedia.org/wiki/Stoke_City', 1),
(14, 'Aston Villa', 'The Villa', 'Villa Park', 42786, 82, 'http://en.wikipedia.org/wiki/Aston_Villa', 1),
(15, 'Everton', 'The Toffees', 'Goodison Park', 40157, 82, 'http://en.wikipedia.org/wiki/Everton_FC', 1),
(16, 'Tottenham Hotspur', 'Spurs', 'White Hart Lane', 36310, 86, 'http://en.wikipedia.org/wiki/Tottenham_Hotspur', 1),
(17, 'Blackburn Rovers', 'Rovers', 'Ewood Park', 31367, 81, 'http://en.wikipedia.org/wiki/Blackburn_Rover
To view the full dump, please login
SQL database dumps

Football teams

Navigation

Popular databases
