TalkPHP - View Single Post

delayedinsanity · 04-03-2008, 05:39 PM

Now I feel silly. Thanks Eric, that worked. I tried this query based on that to try and delete rows from each table, or just a row from the contact table if no match was found in the additional table, and I wound up deleting ALL the records in the additional table (argh!);

Code:

DELETE FROM contact, contact_additional
USING contact, contact_additional
WHERE (contact.ticket=contact_additional.ticket AND contact.ticket='mm1234.1234')
OR contact.ticket='mm1234.1234';

04-03-2008, 05:39 PM	#6 (permalink)
delayedinsanity is cute and cuddly Join Date: Mar 2008 Location: Vegas, Baby Posts: 963 Thanks: 31	Now I feel silly. Thanks Eric, that worked. I tried this query based on that to try and delete rows from each table, or just a row from the contact table if no match was found in the additional table, and I wound up deleting ALL the records in the additional table (argh!); Code: DELETE FROM contact, contact_additional USING contact, contact_additional WHERE (contact.ticket=contact_additional.ticket AND contact.ticket='mm1234.1234') OR contact.ticket='mm1234.1234';