[Problem] Z linią poleceń navicat

[damian11422]

Chcę dodać to na serwer i gdy to wkleje i nacisne enter to sie pojawia takie coś:

 

 

mysql> INSERT INTO `item_proto` VALUES (48700, Zbroja Milenium Sura Zbroja Milenium Sura 2, 0, 0, 2, 44, 1, 1, 100000000, 0, 12020, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

INSERT INTO `item_proto` VALUES (48710, Zbroja Milenium Ninja Zbroja Milenium Ninja 2, 0, 0, 2, 52, 1, 1, 100000000, 0, 12030, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

INSERT INTO `item_proto` VALUES (48720, Zbroja Milenium Shaman Zbroja Milenium Shaman 2, 0, 0, 2, 28, 1, 1, 100000000, 0, 12040, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

INSERT INTO `item_proto` VALUES (48730, Zbroja Milenium Woj Zbroja Milenium Woj 2, 0, 0, 2, 56, 1, 1, 100000000, 0, 12050, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

INSERT INTO `item_proto` VALUES (48740, Zbroja Milenium1 Sura Zbroja Milenium Sura 2, 0, 0, 2, 44, 1, 1, 100000000, 0, 12020, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

INSERT INTO `item_proto` VALUES (48750, Zbroja Milenium1 Ninja Zbroja Milenium Ninja 2, 0, 0, 2, 52, 1, 1, 100000000, 0, 12030, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

INSERT INTO `item_proto` VALUES (48760, Zbroja Milenium1 Shaman Zbroja Milenium Shaman 2, 0, 0, 2, 28, 1, 1, 100000000, 0, 12040, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

INSERT INTO `item_proto` VALUES (48770, Zbroja Milenium1 Woj Zbroja Milenium Woj 2, 0, 0, 2, 56, 1, 1, 100000000, 0, 12050, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

INSERT INTO `item_proto` VALUES (48780, Zbroja Milenium2 Sura Zbroja Milenium Sura 2, 0, 0, 2, 44, 1, 1, 100000000, 0, 12020, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

INSERT INTO `item_proto` VALUES (48790, Zbroja Milenium2 Ninja Zbroja Milenium Ninja 2, 0, 0, 2, 52, 1, 1, 100000000, 0, 12030, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

INSERT INTO `item_proto` VALUES (48800, Zbroja Milenium2 Shaman Zbroja Milenium Shaman 2, 0, 0, 2, 28, 1, 1, 100000000, 0, 12040, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

INSERT INTO `item_proto` VALUES (48810, Zbroja Milenium2 Woj Zbroja Milenium Woj 2, 0, 0, 2, 56, 1, 1, 100000000, 0, 12050, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

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 'Milenium Sura Zbroja Milenium Sura 2, 0, 0, 2, 44, 1, 1, 100000000, 0, 12020, 8' at line 1

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 'Milenium Ninja Zbroja Milenium Ninja 2, 0, 0, 2, 52, 1, 1, 100000000, 0, 12030,' at line 1

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 'Milenium Shaman Zbroja Milenium Shaman 2, 0, 0, 2, 28, 1, 1, 100000000, 0, 1204' at line 1

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 'Milenium Woj Zbroja Milenium Woj 2, 0, 0, 2, 56, 1, 1, 100000000, 0, 12050, 803' at line 1

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 'Milenium1 Sura Zbroja Milenium Sura 2, 0, 0, 2, 44, 1, 1, 100000000, 0, 12020, ' at line 1

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 'Milenium1 Ninja Zbroja Milenium Ninja 2, 0, 0, 2, 52, 1, 1, 100000000, 0, 12030' at line 1

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 'Milenium1 Shaman Zbroja Milenium Shaman 2, 0, 0, 2, 28, 1, 1, 100000000, 0, 120' at line 1

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 'Milenium1 Woj Zbroja Milenium Woj 2, 0, 0, 2, 56, 1, 1, 100000000, 0, 12050, 80' at line 1

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 'Milenium2 Sura Zbroja Milenium Sura 2, 0, 0, 2, 44, 1, 1, 100000000, 0, 12020, ' at line 1

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 'Milenium2 Ninja Zbroja Milenium Ninja 2, 0, 0, 2, 52, 1, 1, 100000000, 0, 12030' at line 1

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 'Milenium2 Shaman Zbroja Milenium Shaman 2, 0, 0, 2, 28, 1, 1, 100000000, 0, 120' at line 1

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 'Milenium2 Woj Zbroja Milenium Woj 2, 0, 0, 2, 56, 1, 1, 100000000, 0, 12050, 80' at line 1

mysql>

refresh

refresh

no kurcze pomoże ktoś?

[4FunLucek]

musisz dodać "," (przecinek) pomiędzy nazwy danego itemka np:

 

INSERT INTO `item_proto` VALUES (48700, Zbroja Milenium Sura , Zbroja Milenium Sura 2, 0, 0, 2, 44, 1, 1, 100000000, 0, 12020, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

 

 

Jak problem nie ustąpi to pisz ;D

[damian11422]

dalej to samo

[4FunLucek]

no to nie wiem spróbuj dać ' pomiędzy nazwami....

 

INSERT INTO `item_proto` VALUES (48700, 'Zbroja Milenium Sura', 'Zbroja Milenium Sura' 2, 0, 0, 2, 44, 1, 1, 100000000, 0, 12020, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

 

lub

 

INSERT INTO `item_proto` VALUES (48700, 'Zbroja Milenium Sura', Zbroja Milenium Sura 2, 0, 0, 2, 44, 1, 1, 100000000, 0, 12020, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

 

 

@Edit

 

Po nazwie zapomniałeś dać przecinka przed liczbą i tak w każdym zrób ;d

Przykład:

 

INSERT INTO `item_proto` VALUES (48700, Zbroja Milenium Sura, Zbroja Milenium Sura, 2, 0, 0, 2, 44, 1, 1, 100000000, 0, 12020, 803, 0, 0, 1, 50, 0, 0, 8, 10, 37, 25, 0, 0, 0, 350, 0, 24, 0, 100, -1, -1, -1, -1, -1, -1, 100, 3, 0);

[damian11422]

nie działa dalej

[4FunLucek]

to samo pisze?

a z tymi ' patrzałeś też?

[damian11422]

tak to samo napisałem z '

[4FunLucek]

no to wygląda na to, że musisz wpisać ręcznie

[damian11422]

we wszystkim moge wpisać co chce czy musi bić cos co musze wpisać?

[raV18]

INSERT INTO `item_proto` VALUES ('48700', 'Zbroja Milenium Sura', 'Zbroja Milenium Sura', '2', '0', '0', '2', '44', '1', '1',  '100000000', '0', '12020', '803', '0', '0', '1', '50', '0', '0', '8', '10', '37', '25', '0', '0', '0', '350', '0', '24', '0', '100', '-1', '-1', '-1', '-1', '-1', '-1', '100', '3', '0');

spróbuj to jedno dodać, jeśli sie doda to zrób każde w ten sam sposób jak to wyżej.. porównaj co jak jest poprawione, podpowiem że dodane sa " '48700' " takie jakby cudzysłowia,