mysql version 4.x does this -----Original Message----- From: David yahoo [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 5:28 PM To: [EMAIL PROTECTED] Subject: multiple delete for mysql
Hi all, How can i do a delete from multiple table in mysql? Eg : I want ot delete record something like that I dont when to select but delete delete from externallink as link, topic as topic, topiclink as joiner where link.resid = joiner.resid and topic.catid = joiner.catid and topic.rid like "%Industry%"; I want to delete row from link joiner and topic too on cascad that correspond to that. Or have i to do 3 delete ? delete from topic where rid like "%industry%" and now how to delete ? where topic.id "not in" joiner ? and finaly how to delete link that doesnt have their id in joiner ? Thanks. _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
