# \[mySQL\] delete from multiple tables

**URL:** <https://forum.kirupa.com/t/mysql-delete-from-multiple-tables/29252>\
**Category:** programming\
**Created:** [August 24, 2003, 11:21pm UTC](https://forum.kirupa.com/t/mysql-delete-from-multiple-tables/29252 "2003-08-24T23:21:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ahmed](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@ahmed](https://forum.kirupa.com/u/ahmed)\
**Post date:** [August 24, 2003, 11:21pm UTC](https://forum.kirupa.com/t/mysql-delete-from-multiple-tables/29252/1 "2003-08-24T23:21:43Z")

</div>

I’m trying to delete records from two tables (in the same db)… my query statement is structured like this:

```auto
delete from table_1 where id='7'; delete from table_2 where id='7';

```

Now, if I copy and paste that into phpmyadmin, it perfectly works. When it’s part of my script it doesn’t work, however ☹

Anyone got a clue how to fix this? 🙂

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 25, 2003, 2:19am UTC](https://forum.kirupa.com/t/mysql-delete-from-multiple-tables/29252/2 "2003-08-25T02:19:33Z")

</div>

[http://forums.devshed.com/t55986/s.html](http://forums.devshed.com/t55986/s.html)

I don’t think its possible in one statement…

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 25, 2003, 3:28am UTC](https://forum.kirupa.com/t/mysql-delete-from-multiple-tables/29252/3 "2003-08-25T03:28:46Z")

</div>

ah… no worries then… thanks for the link 🙂

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 25, 2003, 9:20pm UTC](https://forum.kirupa.com/t/mysql-delete-from-multiple-tables/29252/4 "2003-08-25T21:20:09Z")

</div>

what happens if you do  
delete from table\_1,table\_2 where id=‘7’; ?  
or if you use a “join”…

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 25, 2003, 9:31pm UTC](https://forum.kirupa.com/t/mysql-delete-from-multiple-tables/29252/5 "2003-08-25T21:31:41Z")

</div>

i didn’t try using the two tables with a comma separating them… that might work 🙂

As for a join, I’ve read on another forum that you can perform a join for deletion 🙂