✔ SQL Fehler im PMA

T

Toysoldier

Grünschnabel
Hallo Leute,

ich baue zur Zeit die Flugpläne meiner Airline ins Buchungssystem via PhpMy Admin und beim Importieren kam Folgender Fehler:

Code: 
SQL-Befehl:

INSERT INTO `flightplan_auw` (`flightNo`, `orgICAO`, `orgApt`, `dstICAO`, `dstApt`, `depTimeLCL`, `depTimeUTC`, `arrTimeLCL`, `arrTimeUTC`, `flightTime`, `aircraft`, `registration`, `dayOfWeek`, `minPaxe`, `maxPaxe`, `altICAO`, `altApt`, `flightlevel`, `cruisingSpeed`, `distance`, `routing`, `booked`) VALUES ('AW454', 'LOWK', 'Klagenfurt', 'GCLP', 'Gran Canaria', '03:35', '01:35', '08:00', '06:00', '04:25', 'B738', 'OE-LNW', 'Sa', 141, 189, 'GCFV', 'Fuerteventura', '390', 'M078', 1840, 'VIW UP976 DETSA UM984 DIVKO UN975 BCN UM985 YES UN747 SVL UN857 KORNO UA857 ABODA UN857 IBALU UA857 AMETA UN857 TURMA UA857 VEDOD UN857 TERTO', ''), ('AW454', 'LOWK', 'Klagenfurt', 'GCLP', 'Gran Canaria', '03:35', '01:35', '08:00', '06:00', '04:25', 'B738', 'OE-LNW', 'So', 141, 189, 'GCFV', 'Fuerteventura', '390', 'M078', 1840, 'VIW UP976 DETSA UM984 DIVKO UN975 BCN UM985 YES UN747 SVL UN857 KORNO UA857 ABODA UN857 IBALU UA857 AMETA UN857 TURMA UA857 VEDOD UN857 TERTO', ''), ('AW192', 'LOWK', 'Klagen[...]

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''

Code: 
INSERT INTO `flightplan_auw` (`flightNo`, `orgICAO`, `orgApt`, `dstICAO`, `dstApt`, `depTimeLCL`, `depTimeUTC`, `arrTimeLCL`, `arrTimeUTC`, `flightTime`, `aircraft`, `registration`, `dayOfWeek`, `minPaxe`, `maxPaxe`, `altICAO`, `altApt`, `flightlevel`, `cruisingSpeed`, `distance`, `routing`, `booked`) VALUES
('AW454', 'LOWK', 'Klagenfurt', 'GCLP', 'Gran Canaria', '03:35', '01:35', '08:00', '06:00', '04:25', 'B738', 'OE-LNW', 'Sa', 141, 189, 'GCFV', 'Fuerteventura', '390', 'M078', 1840, 'VIW UP976 DETSA UM984 DIVKO UN975 BCN UM985 YES UN747 SVL UN857 KORNO UA857 ABODA UN857 IBALU UA857 AMETA UN857 TURMA UA857 VEDOD UN857 TERTO', ''),
('AW454', 'LOWK', 'Klagenfurt', 'GCLP', 'Gran Canaria', '03:35', '01:35', '08:00', '06:00', '04:25', 'B738', 'OE-LNW', 'So', 141, 189, 'GCFV', 'Fuerteventura', '390', 'M078', 1840, 'VIW UP976 DETSA UM984 DIVKO UN975 BCN UM985 YES UN747 SVL UN857 KORNO UA857 ABODA UN857 IBALU UA857 AMETA UN857 TURMA UA857 VEDOD UN857 TERTO', ''),
('AW192', 'LOWK', 'Klagenfurt', 'EBBR', 'Brussels', '07:00', '05:00', '08:15', '06:15', '01:15', 'B738', 'OE-LNW', 'Mo', 98, 185, 'ELLX', 'Luxembourg', '330', 'M078', 482, 'VIW UL608 TGO UZ210 LIRSU UL608 BATTY', ''),
('AW192', 'LOWK', 'Klagenfurt', 'EBBR', 'Brussels', '07:00', '05:00', '08:15', '06:15', '01:15', 'B738', 'OE-LNW', 'Di', 98, 185, 'ELLX', 'Luxembourg', '330', 'M078', 482, 'VIW UL608 TGO UZ210 LIRSU UL608 BATTY', ''),
('AW192', 'LOWK', 'Klagenfurt', 'EBBR', 'Brussels', '07:00', '05:00', '08:15', '06:15', '01:15', 'B738', 'OE-LNW', 'Mi', 98, 185, 'ELLX', 'Luxembourg', '330', 'M078', 482, 'VIW UL608 TGO UZ210 LIRSU UL608 BATTY', ''),
('AW192', 'LOWK', 'Klagenfurt', 'EBBR', 'Brussels', '07:00', '05:00', '08:15', '06:15', '01:15', 'B738', 'OE-LNW', 'Do', 98, 185, 'ELLX', 'Luxembourg', '330', 'M078', 482, 'VIW UL608 TGO UZ210 LIRSU UL608 BATTY', ''),
('AW192', 'LOWK', 'Klagenfurt', 'EBBR', 'Brussels', '07:00', '05:00', '08:15', '06:15', '01:15', 'B738', 'OE-LNW', 'Fr', 98, 185, 'ELLX', 'Luxembourg', '330', 'M078', 482, 'VIW UL608 TGO UZ210 LIRSU UL608 BATTY', ''),
('AW455', 'GCLP', 'Gran Canaria', 'LOWK', 'Klagenfurt', '08:55', '06:55', '12:40', '10:40', '04:45', 'B738', 'OE-LNW', 'Sa', 141, 185, 'LOWW', 'Wien-Schwechat', '380', 'M078', 1845, 'KORAL UG5 ESS UN871 OSDAM UB28 BARPA UM985 BCN UN870 ADITA UT24 STP UM985 MALUG UP978 VIW', ''),
('AW455', 'GCLP', 'Gran Canaria', 'LOWK', 'Klagenfurt', '08:55', '06:55', '12:40', '10:40', '04:45', 'B738', 'OE-LNW', 'So', 141, 185, 'LOWW', 'Wien-Schwechat', '380', 'M078', 1845, 'KORAL UG5 ESS UN871 OSDAM UB28 BARPA UM985 BCN UN870 ADITA UT24 STP UM985 MALUG UP978 VIW', ''),
('AW193', 'EBBR', 'Brussels', 'LOWK', 'Klagenfurt', '09:00', '07:00', '10:15', '08:15', '01:15', 'B738', 'OE-LNW', 'Mo', 98, 185, 'LOWW', 'Wien-Schwechat', '320', 'M078', 482, 'SPI UL607 AMASI UM149 DETEV UL603 OBEDI UL172 VIW', ''),
('AW193', 'EBBR', 'Brussels', 'LOWK', 'Klagenfurt', '09:00', '07:00', '10:15', '08:15', '01:15', 'B738', 'OE-LNW', 'Di', 98, 185, 'LOWW', 'Wien-Schwechat', '320', 'M078', 482, 'SPI UL607 AMASI UM149 DETEV UL603 OBEDI UL172 VIW', ''),
('AW193', 'EBBR', 'Brussels', 'LOWK', 'Klagenfurt', '09:00', '07:00', '10:15', '08:15', '01:15', 'B738', 'OE-LNW', 'Mi', 98, 185, 'LOWW', 'Wien-Schwechat', '320', 'M078', 482, 'SPI UL607 AMASI UM149 DETEV UL603 OBEDI UL172 VIW', ''),
('AW193', 'EBBR', 'Brussels', 'LOWK', 'Klagenfurt', '09:00', '07:00', '10:15', '08:15', '01:15', 'B738', 'OE-LNW', 'Do', 98, 185, 'LOWW', 'Wien-Schwechat', '320', 'M078', 482, 'SPI UL607 AMASI UM149 DETEV UL603 OBEDI UL172 VIW', ''),
('AW193', 'EBBR', 'Brussels', 'LOWK', 'Klagenfurt', '09:00', '07:00', '10:15', '08:15', '01:15', 'B738', 'OE-LNW', 'Fr', 98, 185, 'LOWW', 'Wien-Schwechat', '320', 'M078', 482, 'SPI UL607 AMASI UM149 DETEV UL603 OBEDI UL172 VIW', ''),
('AW1XP', 'LOWK', 'Klagenfurt', 'LGRP', 'Rhodos', '13:45', '11:45', '19:00', '17:00', '04:15', 'B738', 'OE-LNW', 'Mo', 145, 185, 'LGIR', 'Heraklion', '360', 'M078', 889, 'ZAG UL603 RUGAS UN128 LMO N128 ERESO UN127 RIKSO UN128 IMR UN618 OKESA UG80 AKBUK UN128 MILAS UG80 YUNUS UN128 BANRO', ''),
('AW1XP', 'LOWK', 'Klagenfurt', 'LGRP', 'Rhodos', '13:45', '11:45', '19:00', '17:00', '04:15', 'B738', 'OE-LNW', 'Di', 145, 185, 'LGIR', 'Heraklion', '360', 'M078', 889, 'ZAG UL603 RUGAS UN128 LMO N128 ERESO UN127 RIKSO UN128 IMR UN618 OKESA UG80 AKBUK UN128 MILAS UG80 YUNUS UN128 BANRO', ''),
('AW1XP', 'LOWK', 'Klagenfurt', 'LGRP', 'Rhodos', '13:45', '11:45', '19:00', '17:00', '04:15', 'B738', 'OE-LNW', 'Mi', 145, 185, 'LGIR', 'Heraklion', '360', 'M078', 889, 'ZAG UL603 RUGAS UN128 LMO N128 ERESO UN127 RIKSO UN128 IMR UN618 OKESA UG80 AKBUK UN128 MILAS UG80 YUNUS UN128 BANRO', ''),
('AW1XP', 'LOWK', 'Klagenfurt', 'LGRP', 'Rhodos', '13:45', '11:45', '19:00', '17:00', '04:15', 'B738', 'OE-LNW', 'Do', 145, 185, 'LGIR', 'Heraklion', '360', 'M078', 889, 'ZAG UL603 RUGAS UN128 LMO N128 ERESO UN127 RIKSO UN128 IMR UN618 OKESA UG80 AKBUK UN128 MILAS UG80 YUNUS UN128 BANRO', ''),
('AW1XP', 'LOWK', 'Klagenfurt', 'LGRP', 'Rhodos', '13:45', '11:45', '19:00', '17:00', '04:15', 'B738', 'OE-LNW', 'Fr', 145, 185, 'LGIR', 'Heraklion', '360', 'M078', 889, 'ZAG UL603 RUGAS UN128 LMO N128 ERESO UN127 RIKSO UN128 IMR UN618 OKESA UG80 AKBUK UN128 MILAS UG80 YUNUS UN128 BANRO', ''),
('AW1XP', 'LOWK', 'Klagenfurt', 'LGRP', 'Rhodos', '13:45', '11:45', '19:00', '17:00', '04:15', 'B738', 'OE-LNW', 'Sa', 145, 185, 'LGIR', 'Heraklion', '360', 'M078', 889, 'ZAG UL603 RUGAS UN128 LMO N128 ERESO UN127 RIKSO UN128 IMR UN618 OKESA UG80 AKBUK UN128 MILAS UG80 YUNUS UN128 BANRO', ''),
('AW1XP', 'LOWK', 'Klagenfurt', 'LGRP', 'Rhodos', '13:45', '11:45', '19:00', '17:00', '04:15', 'B738', 'OE-LNW', 'So', 145, 185, 'LGIR', 'Heraklion', '360', 'M078', 889, 'ZAG UL603 RUGAS UN128 LMO N128 ERESO UN127 RIKSO UN128 IMR UN618 OKESA UG80 AKBUK UN128 MILAS UG80 YUNUS UN128 BANRO', ''),

Jetzt die Frage was ist da Falsch? Ich habe vorher den SQL Code der bestehenden Flüge Exportiert und einfach nur die neuen Flüge eingebaut und wollte dann halt Importieren. Ich finde kein Fehler! Ich habe wirklich 1:1 so übernommen wie der SQL Code im Original war, lediglich die Werte geändert!
 
Falls der gepostete SQL-Code vollständig ist, solltest du mit Simikolon statt Komma das Query abschliessen.
Ansonste, funktioniert denn eine einzelne VALUE-Liste?
 
Um antworten zu können musst du eingeloggt sein.

Neue Beiträge

Zurück