Skip navigation links

MySQL Forums :: Foreign Keys (Referential Integrity)


Advanced Search

Announcements Last Post
• MySQL Workbench 6.0: BETA 1 released 06/13/2013 07:45PM
• MySQL Community Server 5.1.70 has been released 06/06/2013 08:19AM
• MySQL Community Server 5.5.32 has been released 06/06/2013 07:58AM
• MySQL Community Server 5.6.12 has been released 06/06/2013 07:36AM
Pages:  1 2 3 4 Next
Current Page: 1 of 4
Subject Views Written By Posted
Sticky:  WL#148: Foreign keys: Implement Foreign Keys (all storage engines) (1 Posts)   10,036 Edwin DeSouza 09/26/2007 03:22PM
query to list tables according to relationship   25 jonny quest 06/12/2013 09:32PM
timestamp is not updated on foreign key update   98 Hemant Shah 05/17/2013 06:42PM
Re: timestamp is not updated on foreign key update   27 Peter Brawley 05/25/2013 01:48PM
How know many to many relationship from information schema   204 Jorge prado 03/15/2013 09:45PM
Re: How know many to many relationship from information schema   182 Peter Brawley 03/16/2013 12:34AM
error 1005 (hy000): can't create table reparto.simone (errno:105)   414 simone mancaruso 02/01/2013 07:38AM
Importing dump from relational db while maintaining referential integrity   289 Fredrik Krokstad 01/28/2013 11:03AM
Normalise and uniqueness of a dataset where the combination of three columns is unique and one column is a many to many relationship   457 diego gullo 12/06/2012 05:42AM
error in foreign key constraint definition   485 Matteo Tassinari 11/08/2012 11:00AM
Re: error in foreign key constraint definition   227 george gallen 11/08/2012 01:49PM
Re: error in foreign key constraint definition   494 Matteo Tassinari 11/09/2012 06:34AM
foreing key and Partitioned table   401 Pieter Huiberts 10/19/2012 11:27AM
Foreign Key on part of a unique index   813 Mr Xax 08/10/2012 12:41PM
Can a single foreign key point to multiple primary keys?   656 David Thielen 07/25/2012 08:14AM
Linking table for rows in the same table   749 D Harrison 05/17/2012 07:07PM
Re: Linking table for rows in the same table   306 Philip Flammer 07/23/2012 12:05PM
relationship tables   598 mvpfootball consulting 06/26/2012 09:45AM
Re: relationship tables   337 Philip Flammer 07/23/2012 11:56AM
Foreign keys and indexes autocreation issue   791 Dimitrios Iosifidis 07/06/2012 02:00AM
Re: Foreign keys and indexes autocreation issue   362 Philip Flammer 07/23/2012 11:54AM
change a PK value and all it's FK value   568 DIL DIL 07/20/2012 05:00AM
Re: change a PK value and all it's FK value   344 Philip Flammer 07/23/2012 11:47AM
I can't point foreign key to date field type   671 Andro Meda 07/19/2012 02:55AM
Re: I can't point foreign key to date field type   359 Philip Flammer 07/23/2012 11:44AM
errors with foreign keys   938 Chris B 04/22/2012 09:28PM
Re: errors with foreign keys   552 snehalata ulhe 04/28/2012 02:20AM
Zero Instead of Null Vs Two Tables.   795 Bryce Byrd 04/27/2012 01:23PM
Sql execution error #1005 .response from the database   1,561 giri giri 04/06/2012 02:03PM
Re: Sql execution error #1005 .response from the database   779 dom pie 04/08/2012 03:19PM
"Indirect" foreign key   1,000 Ivar Kråbøl 03/23/2012 04:41PM
como puedo hacer que un tabla se relacione dos veces con otra tabla.   1,066 Oscar Ordoñez Mego 02/13/2012 08:32PM
Deleting Records   1,322 Sushmita Mishra 01/11/2012 11:13PM
Re: Deleting Records   769 Devart Team 01/24/2012 03:04AM
dropping a foreign key   1,738 adams johnson 01/23/2012 04:20AM
dropping foreign keys   1,727 adams johnson 01/08/2012 04:22AM
Re: dropping foreign keys   769 Devart Team 01/10/2012 02:09AM
Re: dropping foreign keys   780 adams johnson 01/10/2012 04:49AM
Re: dropping foreign keys   815 Devart Team 01/10/2012 09:31AM
Re: dropping foreign keys   762 adams johnson 01/10/2012 11:00AM
Re: dropping foreign keys   752 Devart Team 01/11/2012 03:55AM
What is the best way to remove all Foreign Keys for a refactoring   2,325 Noah Goodrich 10/18/2011 10:18AM
Problem with Foreign key creator   1,689 itzik orfan 10/09/2011 02:36AM
Re: Problem with Foreign key creator   783 Devart Team 10/17/2011 12:01AM
how to get only parent table record if no record in child row using Join   2,095 ROHIT GUPTA 10/12/2011 11:06PM
Re: how to get only parent table record if no record in child row using Join   971 Devart Team 10/16/2011 11:45PM
Foreign key constraint failed when trying to add data to the normalised DB   1,748 Chelsea Sanders 09/09/2011 02:37AM
cyclic reference   1,410 Boris Murashin 08/31/2011 01:53PM
ALTER TABLE NOCHECK CONSTRAINT   2,129 Mark Oberg 08/25/2011 07:50AM
on delete cascade differences   2,429 muhamad eawedat 08/23/2011 04:41PM
issues with table joins   1,482 Gaurav J 08/07/2011 08:18PM
Foreign keys and table rename   2,162 Matteo Tassinari 08/03/2011 09:11AM
Re: Foreign keys and table rename   1,075 Devart Team 08/04/2011 12:17AM
Re: Foreign keys and table rename   1,987 Matteo Tassinari 08/04/2011 12:59AM
Re: Foreign keys and table rename   1,108 Devart Team 08/04/2011 02:52AM
Single table, multiple foreign keys, problem with keys   4,373 M F 07/24/2011 03:56AM
Re: Single table, multiple foreign keys, problem with keys   1,239 Devart Team 07/25/2011 01:24AM
Re: Single table, multiple foreign keys, problem with keys   1,127 M F 07/25/2011 02:09AM
Re: Single table, multiple foreign keys, problem with keys   1,101 Devart Team 07/25/2011 02:38AM
Re: Single table, multiple foreign keys, problem with keys   1,055 M F 07/25/2011 03:30AM
Re: Single table, multiple foreign keys, problem with keys   1,457 Devart Team 07/25/2011 04:09AM
Re: Single table, multiple foreign keys, problem with keys   1,025 M F 07/25/2011 05:07AM
DELETE PLEASE   1,767 M F 07/25/2011 02:08AM
Multiple column foreign key   3,868 Shashwat Tripathi 07/18/2011 06:03AM
Re: Multiple column foreign key   1,363 Devart Team 07/20/2011 12:54AM
Re: Multiple column foreign key   1,167 Shashwat Tripathi 07/20/2011 01:27AM
Checking Foreign Key Constraints   2,529 M J 05/20/2011 12:42AM
Re: Checking Foreign Key Constraints   1,056 Devart Team 05/20/2011 02:16AM
Re: Checking Foreign Key Constraints   974 M J 05/20/2011 03:18AM
Foreign Key problems   1,872 Carlos Sarabando 05/13/2011 08:52AM
Re: Foreign Key problems   964 Chad Bourque 05/13/2011 12:00PM
Foreign key problems   2,145 William Bonney 05/12/2011 04:08PM
Re: Foreign key problems   972 Chad Bourque 05/12/2011 08:19PM
1452 Cannot add or update a child row: a foreign key constraint fails (`shaving_shop`.`shipment_export`, CONSTRAINT `FK_SHIPMENT_EXPORT` FOREIGN KEY (`shipment_id`) REFERENCES `sales_order_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE)   3,647 Devendra Maharjan 05/09/2011 01:32AM
Re: 1452 Cannot add or update a child row: a foreign key constraint fails (`shaving_shop`.`shipment_export`, CONSTRAINT `FK_SHIPMENT_EXPORT` FOREIGN KEY (`shipment_id`) REFERENCES `sales_order_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE)   1,479 Chad Bourque 05/10/2011 11:41AM
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails...   5,841 Nathon Hay 05/09/2011 11:20AM
Re: ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails...   2,669 Nathon Hay 05/09/2011 11:22AM
Re: ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails...   2,233 Nathon Hay 05/09/2011 11:39AM
Re: ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails...   4,574 Nathon Hay 05/09/2011 11:44AM
Re: ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails...   2,314 Nathon Hay 05/09/2011 12:37PM
Re: ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails...   2,708 Nathon Hay 05/09/2011 12:41PM
Re: ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails...   2,754 Chad Bourque 05/10/2011 11:32AM
Query   1,875 Suresh kumar 04/28/2011 02:39AM
Re: Query   914 Chad Bourque 04/28/2011 11:21AM
How to give relationships to entity?   1,874 Hakoo Desai 04/11/2011 10:58PM
Insert fails: error 1452, a foreign key constraint fails   9,070 Ken Iisaka 02/15/2011 06:06PM
Re: Insert fails: error 1452, a foreign key constraint fails   3,544 Ken Iisaka 02/15/2011 08:17PM
Re: Insert fails: error 1452, a foreign key constraint fails   3,272 Ken Britton 03/14/2011 02:46PM
Re: Insert fails: error 1452, a foreign key constraint fails   3,042 Ken Iisaka 04/04/2011 06:27PM
Re: Insert fails: error 1452, a foreign key constraint fails   2,692 Damien Lynn 04/05/2011 03:50PM
Loading data into MySQL table with Foreign keys   2,567 Peter Freeman 03/31/2011 09:15PM
Re: Loading data into MySQL table with Foreign keys   1,106 Peter Freeman 04/01/2011 08:50PM
Am I doing this right?   1,853 Sean Duthie 03/24/2011 12:28PM
registros duplicados en mysql   2,293 james andres 03/12/2011 12:47PM
Auto-incrementing fields are unsuitable for keys?   2,025 Gavin Stokes 02/17/2011 04:24PM
Re: Auto-incrementing fields are unsuitable for keys?   1,065 Peter Brawley 02/17/2011 10:28PM
add foreign key fails error 1452   2,486 Aidan Ewen 02/17/2011 05:07AM
constrain between schemas?   2,775 Ohad BP 02/13/2011 08:33AM
Re: constrain between schemas?   1,079 Chad Bourque 02/13/2011 04:31PM
Insert statement across two tables...   4,631 Brian O'Brien 01/24/2011 06:32PM
Re: Insert statement across two tables...   1,683 Peter Brawley 01/27/2011 09:54PM
Re: Insert statement across two tables...   1,668 Brian O'Brien 01/28/2011 11:50AM
Re: Insert statement across two tables...   1,416 Peter Brawley 02/11/2011 10:50AM
Pages:  1 2 3 4 Next
Current Page: 1 of 4
powered by phorum

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.