subject:"Delete from another table on update."

Re: Delete from another table on update.

2012-02-06 Thread Halï¿½sz Sï¿½ndor

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

Delete from another table on update.

2012-02-06 Thread 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") ? Thanks. -- Paul Halliday http://www.squertproject.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.c