Kriege beim Importieren immer ein Fehler :
#1136 - Column count doesn't match value count at row 1
Folgender Code dafür :
SQL
INSERT INTO `fraktionen` (`frakid`, `frakname`, `maxmembers`, `maxrangs`, `rang1`, `rang2`, `rang3`, `rang4`, `rang5`, `rang6`, `rang7`, `rang8`, `rang9`, `rang10`, `rang11`, `kasse`, `gehalt1`, `gehalt2`, `gehalt3`, `gehalt4`, `gehalt5`, `gehalt6`, `gehalt7`, `gehalt8`, `gehalt9`, `gehalt10`, `gehalt11`, `drugs`, `mats`) VALUES
(1, 'Regierung', 24, 11, 'Rang1', 'Rang2', 'Rang3', 'Rang4', 'Rang5', 'Rang6', 'Rang7', 'Rang8', 'Rang9', 'Rang10', 'Rang11', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(2, 'SAPD', 45, 11, 'Rang1 ', 'Rang2', 'Rang3', 'Rang4', 'Rang5', 'Rang6', 'Rang7', 'Rang8', 'Rang9', 'Rang10', 'Rang11', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3, 'FBI', 40, 11, 'Rang1', 'Rang2', 'Rang3', 'Rang4', 'Rang5', 'Rang6', 'Rang7', 'Rang8', 'Rang9', 'Rang10', 'Rang11', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(4, 'Ordnungsamt', 25, 11, 'Rang1', 'Rang2', 'Rang3', 'Rang4', 'Rang5', 'Rang6', 'Rang7', 'Rang8', 'Rang9', 'Rang10', 'Rang11', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(5, 'San News', 12, 11, 'Rang1', 'Rang2', 'Rang3', 'Rang4', 'Rang5', 'Rang6', 'Rang7', 'Rang8', 'Rang9', 'Rang10', 'Rang11', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(6, 'Sanitäter', 26, 11, 'Rang1', 'Rang2', 'Rang3', 'Rang4', 'Rang5', 'Rang6', 'Rang7', 'Rang8', 'Rang9', 'Rang10', 'Rang11', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(7, 'Grove Street', 25, 11, 'Rang1', 'Rang2', 'Rang3', 'Rang4', 'Rang5', 'Rang6', 'Rang7', 'Rang8', 'Rang9', 'Rang10', 'Rang11', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(8, 'Ballas', 25, 11, 'Baller', 'Rang1', 'Rang2', 'Rang3', 'Rang4', 'Rang5', 'Rang6', 'Rang7', 'Rang8', 'Rang9', 'Rang10', 'Rang11', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(9, 'Triaden', 25, 11, 'Rang1', 'Rang2', 'Rang3', 'Rang4', 'Rang5', 'Rang6', 'Rang7', 'Rang8', 'Rang9', 'Rang10', 'Rang11', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(10, 'Hitman-Agency', 25, 11, 'Rang1', 'Rang2', 'Rang3', 'Rang4', 'Rang5', 'Rang6', 'Rang7', 'Rang8', 'Rang9', 'Rang10', 'Rang11', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
Alles anzeigen
Brauche Hilfe!