cascade and restrict together mysql 5.0

[cgraz]

I'm pretty sure this is possible, although I may be overthinking this at 2am. In essence, I'd like to be able to say ON DELETE CASCADE, RESTRICT. Here's the more detailed explanation:

I have a table A that has a foreign key UserID from the Users table. If someone tries to delete a user from the Users table, i want to run a restrict so that any corresponding entries in table A are not removed. The person would have to remove the result(s) fromtable A, then go to the Users table to delete the user.

However, if there are no corresponding entries in table A with this UserID, then I'd like the delete to cascade down to table A when the user is delete from the Users table.

Is this possible? Am I overthinking a simple solution?

[Lars_Berg]

If there are no corresponding records in table A, what would you want to delete from that table? As you describe it, it seems as on delete restrict would do nicely.