• Register
0 votes
194 views

Problem :

When I try to execute the below SQL command :

INSERT INTO mytest_usershosts (RID,userid,hid,Usr,Pass) 
VALUES (NULL,1,1,"user","pass");

I am facing the below error message :

ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint f
ails (`dm`.`mytest_usershosts`, CONSTRAINT `mytest_usershosts_ibfk_1` FOREIGN KEY (`
userid`) REFERENCES `mytest_users` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE)

 

I have already looked into many similar cases, but I am unable to find any solution.

Is there anyone who have faced the same issue and knows the fix for the issue?

7.5k points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

The reason behind you facing that error is that you are trying to insert the record on the table mytest_usershosts but the value of the userID is not present on your table mytest_users. Same for the value of hid it is also not present on table mytest_hosts.

Table mytest_usershosts is dependent on the tables: mytest_users and mytest_hosts. So please make sure that while inserting the records on the table mytest_usershosts, the values for hid and userid should already be available on the following parent tables: mytest_users and mytest_hosts.

Now try executing below query and surely it will be inserted.

INSERT INTO mytest_usershosts (RID,userid,hid,Usr,Pass)

VALUES (NULL,1120,30,'user','pass');

Also the  AUTO_INCREMENT option on the tables: mytest_users and mytest_hosts, are needless as you are supplying the values on every query that you are executing on the two tables.

38.6k points

Related questions

0 votes
1 answer 76 views
76 views
Problem: How can I fix this issue:Error 1452: cannot add or update a child row: a foreign key constraint fails .
asked Mar 15 Wafa Abu Yousef 6.1k points
0 votes
2 answers 4.9k views
4.9k views
Problem : I have created the tables in MySQL Workbench. But when I try to insert the values into the ORDRELINJE table i get below error: Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails (srdjank.Ordrelinje, CONSTRAINT Ordrelinje_fk FOREIGN KEY ... (OrdreID)) I have seen many other posts on this topic but unable to fix my issue. How can I fix this issue?
asked Jan 24, 2020 jwilliam 3.9k points
0 votes
2 answers 490 views
490 views
Problem : I have created the tables in MySQL Workbench. But when want to insert values into my TBL ORDRELINJE table I face below error : Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails (srdjank.TBLOrdrelinje, CONSTRAINT TBLOrdrelinje_fk FOREIGN KEY ... do the research on this topic, but no luck. Am I doing any mistake or someone have any idea about what can I do?
asked Dec 21, 2019 alecxe 7.5k points
0 votes
1 answer 21 views
21 views
Problem: 1452 - cannot add or update a child row: a foreign key constraint fails
asked Jul 3 asha 121k points
0 votes
1 answer 29 views
29 views
Problem: table 1 +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------------- ... /table2`, CONSTRAINT `table2_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `table1` (`UserID`)) What have I done wrong? I read http://www.w3schools.com/Sql/sql_foreignkey.asp and I don't see what's wrong.
asked Apr 26 anika11 32.2k points
0 votes
1 answer 34 views
34 views
Problem: Mysql error 1452 - Cannot add or update a child row: a foreign key constraint fails.How to resolve this error?
asked Apr 21 Humaira ahmed 50.7k points
1 vote
1 answer 39 views
39 views
Problem: How to figure out this in mYSQL? Error 1217 (23000): cannot delete or update a parent row: a foreign key constraint fails.
asked Apr 24 PkGuy 25.9k points
0 votes
1 answer 436 views
436 views
Problem : In the MySQL I am trying to drop the table named bericht. I tried many options however still facing the same error that my table cannot be dropped. I am facing following error message : #1217 - Cannot delete or update a parent row: a foreign key constraint fails Does anybody have any clue about this error #1217?
asked Dec 2, 2019 alecxe 7.5k points
0 votes
1 answer 24 views
24 views
Problem: Error:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`myapp/table2`, CONSTRAINT `table2_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `table1` (`UserID`)) What have I done wrong? I read http://www.w3schools.com/Sql/sql_foreignkey.asp and I don't see what's wrong.
asked May 4 sumaiya simi 43.9k points
1 vote
1 answer 92 views
92 views
Problem: I keep getting this error whenever I try to use the delete statement . Error: 1451 - Cannot delete or update a parent row: a foreign key constraint fails (paymesomething.advertisers, CONSTRAINT advertisers_ibfk_1 FOREIGN KEY (advertiser_id) REFERENCES jobs (advertiser_id)) ... (`advertiser_id`) REFERENCES `jobs` (`advertiser_id`); Why am I getting this error and how can I solve this ?
asked Apr 26 Raj Tyagi 16k points