LMSouq
database Open

ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

US
user3289677
1 month ago
3 views
Problem Description
I have created tables in MySQL Workbench as shown below : **ORDRE table:** CREATE TABLE Ordre ( OrdreID INT NOT NULL, OrdreDato DATE DEFAULT NULL, KundeID INT DEFAULT NULL, CONSTRAINT Ordre_pk PRIMARY KEY (OrdreID), CONSTRAINT Ordre_fk FOREIGN KEY (KundeID) REFERENCES Kunde (KundeID) ) ENGINE = InnoDB; **PRODUKT table:** CREATE TABLE Produkt ( ProduktID INT NOT NULL, ProduktBeskrivelse VARCHAR(100) DEFAULT NULL, ProduktFarge VARCHAR(20) DEFAULT NULL, Enhetpris INT DEFAULT NULL, CONSTRAINT Produkt_pk PRIMARY KEY (ProduktID) ) ENGINE = InnoDB; and **ORDRELINJE table:** CREATE TABLE Ordrelinje ( Ordre INT NOT NULL, Produkt INT NOT NULL, AntallBestilt INT DEFAULT NULL, CONSTRAINT Ordrelinje_pk PRIMARY KEY (Ordre, Produkt), CONSTRAINT Ordrelinje_fk FOREIGN KEY (Ordre) REFERENCES Ordre (OrdreID), CONSTRAINT Ordrelinje_fk1 FOREIGN KEY (Produkt) REFERENCES Produkt (ProduktID) ) ENGINE = InnoDB; so when I try to insert values into `ORDRELINJE` table i get: >Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails (`srdjank`.`Ordrelinje`, CONSTRAINT `Ordrelinje_fk` FOREIGN KEY (`Ordre`) REFERENCES `Ordre` (`OrdreID`)) I've seen the other posts on this topic, but no luck. Am I overseeing something or any idea what to do?

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base