MySQL Lists: mysql: Delete from another table on update.

List:	General Discussion	« Previous Message Next Message »
From:	Paul Halliday	Date:	February 6 2012 3:33pm
Subject:	Delete from another table on update.
View as plain text

Is it possible to wrap a DELETE statement in an ON DUPLICATE KEY UPDATE?

Something like: ON DUPLICATE KEY UPDATE host="b1" (DELETE FROM
another_table WHERE host="b1") ?

Thanks.

-- 
Paul Halliday
http://www.squertproject.org/

Thread
• Delete from another table on update.	Paul Halliday	6 Feb
• Re: Delete from another table on update.	hsv	6 Feb