Micah Gersten wrote:
Colin Guthrie wrote:
The ON DELETE CASCADE option is key here... "DELETE FROM students
where student_id=1" will remove all traces of that student from the
db... all the course they've attended, all the instructors who have
taught them etc. keeps things nice and tidy without having to put the
structure in your code all over the place.
Col
Why would you want to delete the instructors when deleting the student?
I think he meant the link between the student & instructor (in the
student_instructor table), not the instructor itself.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
