Timeline for How do I prove that the act of removing foreign keys doesn't corrupt existing data?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 15, 2020 at 9:05 | history | edited | CommunityBot |
Commonmark migration
|
|
| Aug 20, 2014 at 22:18 | comment | added | Vérace | Just as a matter of interest Rolando, why not use something like this as your queries to detect orphans and barren parents? SELECT c.id, c.parent_id, c.identifier from child c where c.parent_id NOT IN (SELECT id FROM parent); and SELECT p.id, p.identifier FROM parent p WHERE p.id NOT IN (SELECT parent_id FROM child); What I'm trying to get at is why you choose your form of the query rather than what seems to me to be somewhat simpler? | |
| Aug 20, 2014 at 21:23 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
added 19 characters in body
|
| Aug 20, 2014 at 21:16 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |