[ markonatom @ 14.09.2012. 17:48 ] @
Pri unosu podataka pomocu komande insert javljaju mi se sledece greske: mysql> insert into StavkaRacuna (STAVKA_ID, DVD_ID, RACUN_ID, STAVKA_REDNIBROJ, STAVKA_KOMADA) -> values (125, 12, 231, 133, 3); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint f ails (`jeca`.`stavkaracuna`, CONSTRAINT `FK_PRIPADA_RACUNU` FOREIGN KEY (`RACUN_ ID`) REFERENCES `racun` (`RACUN_ID`)) mysql> mysql> insert into Racun (RACUN_ID, CLAN_ID, RACUN_DATUM, RACUN_UKUPNACENA, RACU N_NACINPLACANJA) -> values (333, 133, '2012-09-13', 400, 'kes'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint f ails (`jeca`.`racun`, CONSTRAINT `FK_IZDAVANJE` FOREIGN KEY (`CLAN_ID`) REFERENC ES `clan` (`CLAN_ID`)) Napravio sam 5 tabela, sa 3 nisma imao problema ali kada pokusam da unesem podatke za ove dve tabele dobijam navedene greske. Da li neko zna o cemu se radi? |