Football player database containing soccer players from major leagues including premier league and la liga

Preview
CREATE TABLE IF NOT EXISTS `football_players` (
  `player_id` int(11) NOT NULL AUTO_INCREMENT,
  `team_id` int(11) NOT NULL,
  `country_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `player_full_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `player_number` int(11) NOT NULL,
  `player_position` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `player_position_2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `player_position_general` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `player_current_position` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `player_position_full` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `player_stat` int(11) NOT NULL,
  `player_international` tinyint(1) NOT NULL DEFAULT '0',
  `player_international_caps` int(11) NOT NULL,
  `player_international_goals` int(11) NOT NULL,
  PRIMARY KEY (`player_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3440 ;


INSERT INTO `football_players` (`player_id`, `team_id`, `country_name`, `player_full_name`, `player_number`, `player_position`, `player_position_2`, `player_position_general`, `player_current_position`, `player_position_full`, `player_stat`, `player_international`, `player_international_caps`, `player_international_goals`) VALUES
(315, 2, 'England', 'Paul Robinson', 4, 'LB', '', 'DF', 'LB', 'Left Back', 77, 0, 0, 0),
(316, 2, 'England', 'Gary Cahill', 5, 'CB', '', 'DF', 'CB', 'Defender', 83, 1, 3, 0),
(314, 2, 'Spain', 'Marcos Alonso', 3, 'RWB', '', 'DF', 'SUB', 'Wingback', 63, 0, 0, 0),
(312, 2, 'Hungary', 'Ádám Bogdán', 1, 'GK', '', 'GK', 'GK', 'Goalkeeper', 70, 0, 0, 0),
(313, 2, 'Iceland', 'Grétar Steinsson', 2, 'RB', '', 'DF', 'RES', 'Right back', 72, 0, 0, 0),
(309, 1, 'England', 'Alex Nimely', 43, 'FW', '', 'FW', 'RES', 'Striker', 66, 0, 0, 0),
(310, 1, 'Italy', 'Mario Balotelli', 45, 'FW', '', 'FW', 'SUB', 'Striker[1]', 87, 1, 3, 0),
(311, 1, 'Côte d''Ivoire', 'Abdul Razak', 62, 'CM', '', 'MF', 'RES', 'Midfielder', 69, 0, 0, 0),
(308, 1, 'Côte d''Ivoire', 'Yaya Touré', 42, 'CM', '', 'MF', 'SUB', 'Midfielder', 87, 1, 58, 8),
(307, 1, 'Slovakia', 'Vladimír Weiss', 40, 'RW', 'LW', 'MF', 'RES', 'Winger', 69, 0, 0, 0),
(301, 1, 'Argentina', 'Carlos Tévez', 32, 'FW', '', 'FW', 'FW', 'Forward', 91, 1, 62, 13),
(302, 1, 'Republic of Ireland', 'Greg Cunningham', 33, 'LB', 'LM', 'DF', 'RES', 'Left back / Left midfielder', 67, 0, 0, 0),
(303, 1, 'Netherlands', 'Nigel de Jong', 34, 'CDM', '', 'MF', 'RES', 'Defensive midfielder', 79, 1,
To view the full dump, please login
SQL database dumps

Football players

Navigation

Popular databases
