>>>> 2012/02/06 11:33 -0400, Paul Halliday >>>> 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") ? <<<<<<<< No; see http://dev.mysql.com/doc/refman/5.5/en/insert.html Such things are done in triggers, also if you only on duplicate key want the deletion. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql