mysql - 一起使用重复更新低优先级上的插入延迟

Question

我想要一个将插入或更新但使用低优先级或延迟的 mysql 语句。这似乎不起作用

INSERT DELAYED INTO lastaccess
            (x, y, timeaccess)
            VALUES (2, 4, 1309622646)
            ON DUPLICATE KEY UPDATE LOW_PRIORITY timeaccess = 1309622646

Answer 1

您的问题是“ON DUPLICATE KEY UPDATE”语句。根据文档，这不适用于 INSERT DELAYED 语句:

INSERT DELAYED should be used only for INSERT statements that specify value lists. The server ignores DELAYED for INSERT ... SELECT or INSERT ... ON DUPLICATE KEY UPDATE statements.

http://dev.mysql.com/doc/refman/5.5/en/insert-delayed.html