List:General Discussion« Previous MessageNext 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 Halliday6 Feb
  • Re: Delete from another table on update.hsv6 Feb