Code: Alles auswählen
DROP TABLE IF EXISTS `phpbb_em_games`;
CREATE TABLE IF NOT EXISTS `phpbb_em_games` (
`game_id` mediumint(8) NOT NULL auto_increment,
`game_time` int(11) NOT NULL default '0',
`game_home` mediumint(8) NOT NULL default '0',
`game_away` mediumint(8) NOT NULL default '0',
`game_loc` varchar(255) NOT NULL default '',
`game_loclink` varchar(255) NOT NULL default '',
PRIMARY KEY (`game_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;
INSERT INTO `phpbb_em_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES
(19, 1213641900, 8, 6, 'Klagenfurt', ''),
(18, 1213555500, 4, 2, 'Genf', ''),
(17, 1213555500, 1, 3, 'Basel', ''),
(16, 1213469100, 13, 16, 'Salzburg', ''),
(15, 1213459200, 14, 15, 'Innsbruck', ''),
(14, 1213382700, 9, 12, 'Bern', ''),
(13, 1213372800, 10, 11, 'Zürich', ''),
(12, 1213296300, 5, 8, 'Wien', ''),
(11, 1213286400, 6, 7, 'Klagenfurt', ''),
(10, 1213209900, 1, 4, 'Basel', ''),
(9, 1213200000, 2, 3, 'Genf', ''),
(8, 1213123500, 13, 14, 'Salzburg', ''),
(7, 1213113600, 15, 16, 'Innsbruck', ''),
(6, 1213037100, 9, 10, 'Bern', ''),
(5, 1213027200, 11, 12, 'Zürich', ''),
(4, 1212950700, 7, 8, 'Klagenfurt', ''),
(3, 1212940800, 5, 6, 'Wien', ''),
(2, 1212864300, 3, 4, 'Genf', ''),
(1, 1212854400, 1, 2, 'Basel', ''),
(20, 1213641900, 5, 7, 'Wien', ''),
(21, 1213728300, 9, 11, 'Bern', ''),
(22, 1213728300, 12, 10, 'Zürich', ''),
(23, 1213814700, 13, 15, 'Salzburg', ''),
(24, 1213814700, 16, 14, 'Innsbruck', '');
Wo liegt das Problem, dass MySQL hier den Befehl nicht ausführt?