Autor Zpráva
PanP
Profil
Zdar,muže mi někdo pomoct v čem je chyba?v databazi nejsem expert..dik
INSERT INTO `compspecials` 

(`csID`,`csNAME`,`csJOB`,`csCOST`,`csMONEY`,`csCRYSTALS`,`csITEM`,`csENDU`,`csIQ`,`csLABOUR`,`csSTR`) 

VALUES  

('NULL','Labour Pack [ +100 ]','6','10','0','0','0','0','0','100','0'),
('NULL','Strength Pack [ +100 ]','6','10','0','0','0','0','0','0','100'),
('NULL','IQ Pack [ +100 ]','6','10','0','0','0','0','100','0','0'),
('NULL','Endurance Pack [ +100 ]','6','10','0','0','0','100','0','0','0'),
('NULL','Crystal Pack [ +25 ]','6','25','0','25','0','0','0','0','0'),
('NULL','Money Pack [ +5000 ]','6','25','5000','0','0','0','0','0','0'),
('NULL','Special Pack [ Every Other Pack ]','6','75','5000','25','0','100','100','100','100'),
('NULL','Labour Pack [ +100 ]','5','10','0','0','0','0','0','100','0'),
('NULL','Strength Pack [ +100 ]','5','10','0','0','0','0','0','0','100'),
('NULL','IQ Pack [ +100 ]','5','10','0','0','0','0','100','0','0'),
('NULL','Endurance Pack [ +100 ]','5','10','0','0','0','100','0','0','0'),
('NULL','Crystal Pack [ +25 ]','5','25','0','25','0','0','0','0','0'),
('NULL','Money Pack [ +5000 ]','5','25','5000','0','0','0','0','0','0'),
('NULL','Special Pack [ Every Other Pack ]','5','75','5000','25','0','100','100','100','100'),
('NULL','Labour Pack [ +100 ]','4','10','0','0','0','0','0','100','0'),
('NULL','Strength Pack [ +100 ]','4','10','0','0','0','0','0','0','100'),
('NULL','IQ Pack [ +100 ]','4','10','0','0','0','0','100','0','0'),
('NULL','Endurance Pack [ +100 ]','4','10','0','0','0','100','0','0','0'),
('NULL','Crystal Pack [ +25 ]','4','25','0','25','0','0','0','0','0'),
('NULL','Money Pack [ +5000 ]','4','25','5000','0','0','0','0','0','0'),
('NULL','Special Pack [ Every Other Pack ]','4','75','5000','25','0','100','100','100','100'),
('NULL','Labour Pack [ +100 ]','3','10','0','0','0','0','0','100','0'),
('NULL','Strength Pack [ +100 ]','3','10','0','0','0','0','0','0','100'),
('NULL','IQ Pack [ +100 ]','3','10','0','0','0','0','100','0','0'),
('NULL','Endurance Pack [ +100 ]','3','10','0','0','0','100','0','0','0'),
('NULL','Crystal Pack [ +25 ]','3','25','0','25','0','0','0','0','0'),
('NULL','Money Pack [ +5000 ]','3','25','5000','0','0','0','0','0','0'),
('NULL','Special Pack [ Every Other Pack ]','3','75','5000','25','0','100','100','100','100'),
('NULL','Labour Pack [ +100 ]','2','10','0','0','0','0','0','100','0'),
('NULL','Strength Pack [ +100 ]','2','10','0','0','0','0','0','0','100'),
('NULL','IQ Pack [ +100 ]','2','10','0','0','0','0','100','0','0'),
('NULL','Endurance Pack [ +100 ]','2','10','0','0','0','100','0','0','0'),
('NULL','Crystal Pack [ +25 ]','2','25','0','25','0','0','0','0','0'),
('NULL','Money Pack [ +5000 ]','2','25','5000','0','0','0','0','0','0'),
('NULL','Special Pack [ Every Other Pack ]','2','75','5000','25','0','100','100','100','100'),
('NULL','Labour Pack [ +100 ]','1','10','0','0','0','0','0','100','0'),
('NULL','Strength Pack [ +100 ]','1','10','0','0','0','0','0','0','100'),
('NULL','IQ Pack [ +100 ]','1','10','0','0','0','0','100','0','0'),
('NULL','Endurance Pack [ +100 ]','1','10','0','0','0','100','0','0','0'),
('NULL','Crystal Pack [ +25 ]','1','25','0','25','0','0','0','0','0'),
('NULL','Money Pack [ +5000 ]','1','25','5000','0','0','0','0','0','0'),
('NULL','Special Pack [ Every Other Pack ]','1','75','5000','25','0','100','100','100','100');        



a píše to po nahraní tuto chybu
PanP
Profil
a chyba

Chyba

SQL-dotaz:

INSERT INTO `compspecials` (`csID`,`csNAME`,`csJOB`,`csCOST`,`csMONEY`,`csCRYSTALS`,`csITEM`,`csENDU`,`csIQ`,`csLABOUR`,`csSTR`) VALUES ('NULL','Labour Pack [ +100 ]','6','10','0','0','0','0','0','100','0'), ('NULL','Strength Pack [ +100 ]','6','10','0','0','0','0','0','0','100'), ('NULL','IQ Pack [ +100 ]','6','10','0','0','0','0','100','0','0'), ('NULL','Endurance Pack [ +100 ]','6','10','0','0','0','100','0','0','0'), ('NULL','Crystal Pack [ +25 ]','6','25','0','25','0','0','0','0','0'), ('NULL','Money Pack [ +5000 ]','6','25','5000','0','0','0','0','0','0'), ('NULL','Special Pack [ Every Other Pack ]','6','75','5000','25','0','100','100','100','100'), ('NULL','Labour Pack [ +100 ]','5','10','0','0','0','0','0','100','0'), ('NULL','Strength Pack [ +100 ]','5','10','0','0','0','0','0','0','100'), ('NULL','IQ Pack [ +100 ]','5','10','0','0','0','0','100','0','0'), ('NULL','Endurance Pack [ +100 ]','5','10','0','0','0','100','0','0','0'), ('NULL','Crystal Pack [ +25 ]','5','2[...]

MySQL hlásí: Dokumentace
#1062 - Duplicate entry '0' for key 'PRIMARY'
Tori
Profil
(NULL,'Labour Pack [ +100 ]','6','10','0','0','0','0','0','100','0'),
Ty apostrofy tam nemají být.
PanP
Profil
tak už to mam díkes

Vaše odpověď

Mohlo by se hodit


Prosím používejte diakritiku a interpunkci.

Ochrana proti spamu. Napište prosím číslo dvě-sta čtyřicet-sedm: