INSERT DELAYED ...

The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. INSERT语句的DELAYED选项是对标准SQL的MySQL扩展。In previous versions of MySQL, it can be used for certain kinds of tables (such as MyISAM), such that when a client uses INSERT DELAYED, it gets an okay from the server at once, and the row is queued to be inserted when the table is not in use by any other thread.在以前的MySQL版本中，它可以用于某些类型的表（比如MyISAM），这样当客户端使用INSERT DELAYED时，它会立即从服务器获得ok，当其他线程不使用该表时，该行会排队等待插入。

DELAYED inserts and replaces were deprecated in MySQL 5.6. DELAYED的插入和替换在MySQL5.6中被弃用。In MySQL 8.0, DELAYED is not supported. 在MySQL 8.0中，不支持DELAYED。The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: 服务器识别但忽略DELAYED关键字，将插入作为非延迟插入处理，并生成ER_WARN_LEGACY_SYNTAX_CONVERTED警告：INSERT DELAYED is no longer supported. The statement was converted to INSERT. 不再支持INSERT DELAYED。语句已转换为INSERT。The DELAYED keyword is scheduled for removal in a future release.DELAYED关键字计划在将来的版本中删除。