From: Paul Halliday Date: February 6 2012 3:33pm Subject: Delete from another table on update. List-Archive: http://lists.mysql.com/mysql/226733 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 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/