Code:
CREATE TABLE `property_comment`(
`id` int auto_increment NOT NULL PRIMARY KEY,
`property_id` int,
`autor_id` int,
`comment` varchar(500),
FOREIGN KEY(`property_id`) REFERENCES `property`(`id`) ON UPDATE CASCADE ON DELETE CASCADE,
FOREIGN KEY(`autor_id`) REFERENCES `user`(`id`) ON UPDATE CASCADE ON DELETE CASCADE
)ENGINE InnoDb DEFAULT CHARSET=utf8;
CREATE TABLE `property_comment`(
`id` int auto_increment NOT NULL PRIMARY KEY,
`property_id` int,
`autor_id` int,
`comment` varchar(500),
FOREIGN KEY(`property_id`) REFERENCES `property`(`id`) ON UPDATE CASCADE ON DELETE CASCADE,
FOREIGN KEY(`autor_id`) REFERENCES `user`(`id`) ON UPDATE CASCADE ON DELETE CASCADE
)ENGINE InnoDb DEFAULT CHARSET=utf8;
Posto sam napravio opciju za eksport podataka iz nje u tekst fajl potrebno mi je da napravim i ucitavanje tih podataka iz txt fajla.
Kad izbrisem sve podatke i pokusam da ucitam u bazu komandom
Code:
LOAD DATA INFILE 'C:\AgencyDatabaseExports\06-14-2011(07-21-49)\property_comment.txt' INTO TABLE property_comment
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n' (id,property_id,autor_id,`comment`,date_entered);
LOAD DATA INFILE 'C:\AgencyDatabaseExports\06-14-2011(07-21-49)\property_comment.txt' INTO TABLE property_comment
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n' (id,property_id,autor_id,`comment`,date_entered);
on mi prijavi gresku
Citat:
Error Code: 1452
Cannot add or update a child row: a foreign key constraint fails (`agencije`.`property_comment`, CONSTRAINT `property_comment_ibfk_1` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
Cannot add or update a child row: a foreign key constraint fails (`agencije`.`property_comment`, CONSTRAINT `property_comment_ibfk_1` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
Iako mi u ostalim tabelama povezanim sa ovom postoje rekordi sa kljucemima i sve bi trebalo da bude regularno.
Kad sam pokusao da iskljucim proveru kljuceva
Code:
SET FOREIGN_KEY_CHECKS = 0;
SET FOREIGN_KEY_CHECKS = 0;
onda ucitavanje prodje ali podatci koji se ucitaju u tabelu nemaju veze sa onim sto se nalazi u txt fajlu, on po nekoj logici uzme neke podatke iz druge tabele i ubaci ih u ovu tabelu.
Zna li iko kako da odradim ucitavanje podataka iz txt fajla u tabelu koja ima strane kljuceve.
Kad covjeka napusti Sunce njegovog zavicaja ko ce mu posvijetliti na putu povratka