> 
> **Possible Duplicate:**  
> 
> [MySQL delete row from multiple tables](https://stackoverflow.com/questions/2214433/mysql-delete-row-from-multiple-tables) 
> 
> 
> 

I have 5 tables:

* members
* member\_videos
* member\_photos
* member\_friends
* member\_pages

When I delete that member, I want to delete all his records from these tables. `member_id` exist in all tables. I'm doing this with 5 queries for each table. Can I use `LEFT JOIN` or something like this do to this in one query?
['https://Stackoverflow.com/questions/9249793', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1020895/']
<http://dev.mysql.com/doc/refman/5.0/en/delete.html>

Check this page, there is a section for multiple-tables DELETE.
I don't think you can. However, I think you can separate the queries with ; and give it as one query to mysql\_query() or whatever you're using. For example:

```
mysql_query('DELETE * FROM members WHERE user_id = 4; DELETE * FROM member_videos WHERE user_id = 4;');

```

and so on :)