LXer: DIY primary/foreign key relationships, again
by LXer from LinuxQuestions.org on (#5EW92)
Published at LXer:
One table has a primary key field and the other has a foreign key field that should refer back to the first table. This isn't always the case, because the tables don't't always come from a database with referential integrity. Sometimes the two tables have their primary and foreign keys entered manually. This post describes a shell script that checks for this and related problems.
Read More...
One table has a primary key field and the other has a foreign key field that should refer back to the first table. This isn't always the case, because the tables don't't always come from a database with referential integrity. Sometimes the two tables have their primary and foreign keys entered manually. This post describes a shell script that checks for this and related problems.
Read More...