Querys einfügen Navicat

Gobiva · 6. Juli 2017

Guten Morgen,

ich versuche gerade eine Waffe einzufügen. Es scheitert aber gerade daran, das sich die Querys die ich mit dem "Item Creator" erstellt habe nicht einfügen lassen.
Ja, ich habe am ende eine neue 0 eingefügt. Ich benutze die Fliege Files reworked.

Hier mal die Querys für Navicat

Spoiler anzeigen

INSERT INTO `item_proto` VALUES ('10000', 'Kristallschwert+0', 'Kristallschwert+0', '1', '0', '0', '2', '32', '1', '16', '', '5000', '5000', '10001', '0', '0', '15', '1', '105', '0', '0', '7', '15', '17', '20', '15', '20', '0', '500', '400', '500', '400', '50', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0', '0');
INSERT INTO `item_proto` VALUES ('10001', 'Kristallschwert+1', 'Kristallschwert+1', '1', '0', '0', '2', '32', '1', '16', '', '5000', '5000', '10002', '0', '0', '15', '1', '105', '0', '0', '7', '15', '17', '20', '15', '20', '0', '500', '400', '500', '400', '50', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0', '0');
INSERT INTO `item_proto` VALUES ('10002', 'Kristallschwert+2', 'Kristallschwert+2', '1', '0', '0', '2', '32', '1', '16', '', '5000', '5000', '10003', '0', '0', '15', '1', '105', '0', '0', '7', '15', '17', '20', '15', '20', '0', '500', '400', '500', '400', '50', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0', '0');
INSERT INTO `item_proto` VALUES ('10003', 'Kristallschwert+3', 'Kristallschwert+3', '1', '0', '0', '2', '32', '1', '16', '', '5000', '5000', '10004', '0', '0', '15', '1', '105', '0', '0', '7', '15', '17', '20', '15', '20', '0', '500', '400', '500', '400', '50', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0', '0');
INSERT INTO `item_proto` VALUES ('10004', 'Kristallschwert+4', 'Kristallschwert+4', '1', '0', '0', '2', '32', '1', '16', '', '5000', '5000', '10005', '0', '0', '15', '1', '105', '0', '0', '7', '15', '17', '20', '15', '20', '0', '500', '400', '500', '400', '50', '-1', '-1', '-1', '-1', '-1', '-1', '30', '3', '0', '0');
INSERT INTO `item_proto` VALUES ('10005', 'Kristallschwert+5', 'Kristallschwert+5', '1', '0', '0', '2', '32', '1', '16', '', '5000', '5000', '10006', '0', '0', '15', '1', '105', '0', '0', '7', '15', '17', '20', '15', '20', '0', '500', '400', '500', '400', '50', '-1', '-1', '-1', '-1', '-1', '-1', '40', '3', '0', '0');
INSERT INTO `item_proto` VALUES ('10006', 'Kristallschwert+6', 'Kristallschwert+6', '1', '0', '0', '2', '32', '1', '16', '', '5000', '5000', '10007', '0', '0', '15', '1', '105', '0', '0', '7', '15', '17', '20', '15', '20', '0', '500', '400', '500', '400', '50', '-1', '-1', '-1', '-1', '-1', '-1', '50', '3', '0', '0');
INSERT INTO `item_proto` VALUES ('10007', 'Kristallschwert+7', 'Kristallschwert+7', '1', '0', '0', '2', '32', '1', '16', '', '5000', '5000', '10008', '0', '0', '15', '1', '105', '0', '0', '7', '15', '17', '20', '15', '20', '0', '500', '400', '500', '400', '50', '-1', '-1', '-1', '-1', '-1', '-1', '60', '3', '0', '0');
INSERT INTO `item_proto` VALUES ('10008', 'Kristallschwert+8', 'Kristallschwert+8', '1', '0', '0', '2', '32', '1', '16', '', '5000', '5000', '10009', '0', '0', '15', '1', '105', '0', '0', '7', '15', '17', '20', '15', '20', '0', '500', '400', '500', '400', '50', '-1', '-1', '-1', '-1', '-1', '-1', '85', '3', '0', '0');
INSERT INTO `item_proto` VALUES ('10009', 'Kristallschwert+9', 'Kristallschwert+9', '1', '0', '0', '2', '32', '1', '16', '', '5000', '5000', '0', '0', '0', '15', '1', '105', '0', '0', '7', '15', '17', '20', '15', '20', '0', '500', '400', '500', '400', '50', '-1', '-1', '-1', '-1', '-1', '-1', '100', '3', '0', '0');

Das zeigt er mir an bei Navicat wenn ich sie einfügen will

1136 - Column count doesn't match value count at row 1
1136 - Column count doesn't match value count at row 1
1136 - Column count doesn't match value count at row 1
1136 - Column count doesn't match value count at row 1
1136 - Column count doesn't match value count at row 1
1136 - Column count doesn't match value count at row 1
1136 - Column count doesn't match value count at row 1
1136 - Column count doesn't match value count at row 1
1136 - Column count doesn't match value count at row 1
1136 - Column count doesn't match value count at row 1
mysql>

Querys einfügen Navicat

Realis3D.xyz - Character designs, weapons, costumes, and more.

[DEV-Service] Systemerstellung C++/Python

[NEW: RARITY] Systeme

TuoraArts.net | PREMIUM GRAPHICS | ANIMATION | TRAILER SERVICES

[C# 50e ONLY] SOURCE PATCHER FOR SALE [NO VIRUSES]

v1.5 helCMS - Most performant website with Payment system for your server

[Service] Patcher & Discord Bot by DNC

[C++ & Python] 🍪🍪🍪Cookies Coding service [Fix System´s -Interface Coding -GUI Reworks -LUA]🍪🍪🍪

Sunrise™Mt2 - Sucht Teammitglieder (komplett)

Paid Service - Nimueh [2D Graphic Service] Recoloring | Design