DELETE in mysql?
| From: | Adv. Systems Design | Date: | Fri, 01 Feb 2002 20:42:49 +0000 |
| Subject: | DELETE in mysql? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16426@lists.php.net to get a copy of this message | ||
sorry if this is painfully obvious but I can't seem to
figure it out...It seems to me (unless I am reading it
waay wrong) that the mysql DELETE command does NOT
allow you to refer to columns from other tables!
I have identified certain records to be deleted from 3
tables and created a temp table to hold the item_id's
to look up and delete...BUT HOW?! Ideally it would be:
DELETE FROM prod, prod_price, prod_cat
WHERE temp.prod_id = prod.prod_id
AND temp.prod_id = prod_price.prod_id
AND temp.prod_id = prod_cat.prod_id
TIA
Luis
=====
----------------------------------------------------
Make it idiot-proof and someone will make a better idiot.
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com