DELETE all INFO from Different tables

eRIC · #1 01-Jun-2004, 04:02

Hi.
I have 7 tables.In all tables i have Id which is same for all tables.
i wan to delete rows which match with Id. how can i do?
for all delete queries (it will be 7) too much.
thanks.

JdS · #2 01-Jun-2004, 07:19

I haven't done this for 7 tables but I have on occasion deleted from multiple tables successfully. try this and see if it works - also assume this is for 7 tables when I am showing just 3 ( yes, I am lazy to type the extra lines

):

PHP Code:


<?php

// the id/data you want to delete
$del_this_id    =  56;
$col            =  '`Id`';

$sql  =  "DELETE
           `t1`, `t2`, `t3`
         FROM
           `t1`, `t2`, `t3`
         WHERE
             `t1`.$col=`t2`.$col
         AND
             `t2`.$col=`t3`.$col
         AND
             `t3`.$col=$del_this_id";
mysql_query( $sql, $conn );
?>

Please note that this is untested! So your feedback will help others in a similar situation.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need some exercises in C++, plus info on GUI programming.	BlockAndBash	C++ Forum	4	18-May-2004 21:07
changing default webpage info	mkyb14	Apache Web Server Forum	2	12-Nov-2003 04:12
Selecting from 2 tables at the same time	soviet	MySQL / PHP Forum	2	08-Nov-2003 00:15
Can an SWF file gather info?	rhino1616	Graphics Forum	3	31-Oct-2003 13:10
select & delete mysql queries	skyloon	MySQL / PHP Forum	1	22-Jul-2003 14:26