Delete from Multiple Tables

[zaver xaver]

Hello,

I am quite new to mysql and i would like some help with deleting from multiple tables. As far as i know i can either use a join delete query or delete sequentially from one table at a time.

In brief: I am working on a web app that allows users to create accounts and also terminate them. In the case that a user closes the account i must delete his information from multiple tables.

I would like to know:

1)Is there a difference performance wise in join-deletion vs deleting from one table at a time?

2)What do you think is the best way to go with deleting a users info from multiple tables?

Any help would be greatly appreciated

Thank you,
Zaver



Edited 1 time(s). Last edit at 03/26/2009 08:01AM by zaver xaver.