How do I specify a mysql cascade rule for the following

fusascame

New Member
In mysql, I've got the following:\[code\]TABLE docs ( ID title content)TABLE specialDocs ( docID -> docs(ID) userID -> users(ID))\[/code\]So specialDocs is a subset of documents that can belong to users.I am wondering: Is it possible to specify a cascade rule so that when a user is deleted, the docs that belong to that user are automatically deleted? (I realize it would be simple to do this if the pointer to users(ID) was a column within the table "docs". However I am unclear if it is possible with a join table like the above...)Thanks in advance for your help
 
Back
Top