Read the MySQL documentation on DELETE. Multi-table deletes are a new feature in 4.x; for the present it's one table at a time.
Cheers - Miles Thompson At 02:44 PM 2/1/2002 -0800, Adv. Systems Design wrote: >Maybe my example attempt is misguided but the idea is >to look up the prod_id from temp to know which records >to delete in the prod, prod_price, prod_cat tables, >all having the prod_id field as a link...just like you >can do in a SELECT statement: >select p.product_id, p.product_price >from product_price as p, temp as t >where t.product_id = p.product_id > >Let me know if what I am asking is unclear. > > >--- Rick Emery <[EMAIL PROTECTED]> wrote: > > You cannot refer to other tables. Which row in temp > > would MYSQL know to > > refer to test the WHERE clause? That is, if temp > > has multiple rows, which > > row in temp would MYSQL check against to determine > > prod_id? > > > > > > -----Original Message----- > > From: Adv. Systems Design > > [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 01, 2002 2:43 PM > > To: PHP List > > Subject: [PHP-DB] DELETE in mysql? > > > > > > 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 > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > To contact the list administrators, e-mail: >[EMAIL PROTECTED] > > >===== >---------------------------------------------------- >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 > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
