• Register

Recent questions tagged foreign-keys

0 votes
1 answer 19 views
Problem: Please provide me with a response to this >Missing key in referenced table for referential constraint.
asked 6 days ago Florina Gulnar 8.5k points
0 votes
1 answer 19 views
Problem: Please provide me with a response to this >Missing key in referenced table for referential constraint.
asked 6 days ago Florina Gulnar 8.5k points
0 votes
1 answer 14 views
Problem: Any solution to this issue > A foreign key cannot refer to a primary key in the same table. true or false?
asked Apr 30 ummeshani 10.8k points
0 votes
1 answer 2 views
Problem: I need someone’s assistance to solve my problem .. Adding foreign key to existing table in mysql
asked Apr 27 Ifra 37.2k points
1 vote
1 answer 8 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 15.6k points
0 votes
1 answer 8 views
Problem: Why doesn't a TRUNCATE on mygroup work? Even though I have ON DELETE CASCADE SET I get: ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (mytest.instance, CONSTRAINT instance_ibfk_1 FOREIGN KEY (GroupID) REFERENCES ... NULL, DateTime DATETIME DEFAULT NULL, FOREIGN KEY (GroupID) REFERENCES mygroup(ID) ON DELETE CASCADE, UNIQUE(GroupID) ) ENGINE=InnoDB;
asked Apr 26 sumaiya simi 43.9k points
0 votes
1 answer 3 views
Problem: Sorry If my question seems too obvious but I still can't find the logic between a relationship of a database model. ONE TO ONE: If I have a customer that has only one address where do I have to put my foreign key ? I first thought it would be a ... ONE TO MANY: And the same question would apply if a customer can have multiple addresses, in which table, should I put my foreign key?
asked Apr 25 muktaa 34.6k points
1 vote
1 answer 10 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 23.5k points
0 votes
1 answer 6 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
0 votes
1 answer 4 views
Problem: Please let me know any solution regarding this ..primary key and foreign key in mysql
asked Apr 19 Ifra 37.2k points
0 votes
1 answer 3 views
Problem: I get this error message: Error Code: 1005. Can't create table 'mytable.#sql-7fb1_7d3a' (errno: 150)
asked Apr 19 ummesalma 29.2k points
0 votes
1 answer 4 views
Problem: I have a question of interest: Is there still a point of using innodb and foreign keys instead of myisam and no foreign keys. If I just do "NO ACTION" on deletes or updates? I hope you got my point of interest :)
asked Apr 18 anika11 32.2k points
0 votes
1 answer 2 views
Problem: Why should I still use InnoDb and foreign keys, if i don't really use the magic of foreign keys in the end in anyway?
asked Apr 18 anika11 32.2k points
0 votes
1 answer 12 views
Problem: If any determinant in a table is a candidate key, is it in bcnf?
asked Apr 15 jamuna1 30.2k points
0 votes
1 answer 6 views
Problem: The primary key in a table would be a determinant, please help me with this?
asked Apr 15 jamuna1 30.2k points
0 votes
1 answer 8 views
Problem: How can a primary key be a foreign key in the same table?
asked Apr 13 jamuna1 30.2k points
0 votes
1 answer 7 views
Problem: Can anyone tell me the solution of this problem? unique/primary keys in table referenced by foreign keys
asked Apr 7 Ifra 37.2k points
0 votes
1 answer 7 views
Problem: anyone who know this problem please help? does foreign key have to be unique
asked Mar 24 Rohit kr 17.5k points
0 votes
1 answer 3 views
Problem : Is there anyone to helo on > 'can a foreign key also be a primary key' ?
asked Mar 17 sadi1982 36.3k points
0 votes
1 answer 15 views
Problem: In database design what do n:m and 1:n mean? Does it have anything to do with keys or relationships?
asked Mar 9 ummesalma 29.2k points