Posts tagged with sql
Sql threesomes.. Two foreign keys, one primary key
Published 12 September 2010 in archive with tags sql So here I am, coding my own business, being a law abiding coder, when out of the blue comes a rather bothersome little problem which really did one on me. I had laid out an awesome plan for my awesome top secret project, a truly awesomely smart database design with relationships to link a rows in a table to rows in the exact same table, one way relationships from A->B. All I needed was a way to cascade them on delete, in other words, make sure when a row is deleted, every relationship (in the relationship table) is deleted along with it. Continue reading …Newer Page 3 of 3 Older