Cascade - is it just for MySQL & is it recommended?

[s0me0ne]

If its not just for mysql and is recommended and good practice i am coding a blog from scratch. Here are my tables

[CODE]posts

id
title
description
pubdate
updated
published[/CODE]

[CODE]categories

id
title
description[/CODE]

[CODE]posts_and_categories

id
post_id
category_id[/CODE]

So when a category is deleted from categories, it needs to cascade the delete to posts_and_categories.

When I update or delete a post it needs to cascade that to posts_and_categories, how would I set this up with mysql syntax and also inside phpmyadmin, i'd like to know both. Thanks.

[laserlight]

Well, the key point is that for the posts_and_categories table, you want:

category_id ... REFERENCES categories(id) ON UPDATE CASCADE ON DELETE CASCADE

where ... denotes the type. If the table already exists, then you would use ALTER TABLE to make it so.

This is not MySQL specific.