I need the ability to 'fake' a transaction in MySQL. I have a table of 'instructors' and a table of 'courses' in a typical one-to-many scheme. I want to be able to remove the instructor and all of his related courses. Any thoughts on how to do this?
Zach
