MySQL 8.0-13.2.6.3 INSERT DELAYED Statement

翻译于 2021-11-08 10:23:07 发布 · 173 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://dev.mysql.com/doc/refman/8.0/en/insert-delayed.html

文章标签：

#mysql #数据库 #database

Mysql 专栏收录该内容

142 篇文章

订阅专栏

MySQL的INSERT DELAYED选项在早期版本中允许延迟插入，以便在表不被其他线程使用时进行。然而，此功能在MySQL5.6中被弃用，并在8.0版本中不再支持。现在，服务器会忽略DELAYED关键字并以非延迟方式处理插入操作，同时发出警告。

INSERT DELAYED ...

The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. 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.

INSERT语句的DELAYED选项是对标准SQL的MySQL扩展。在早期版本的MySQL,它可以用于某些种类的表(如MyISAM),这样,当一个客户机使用插入延迟,它会得到一个好的服务器,和行排队要插入表时不使用任何其他线程。

DELAYED inserts and replaces were deprecated in MySQL 5.6. In MySQL 8.0, DELAYED is not supported. The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT DELAYED is no longer supported. The statement was converted to INSERT. The DELAYED keyword is scheduled for removal in a future release.

延迟插入和替换在MySQL 5.6中已弃用。在MySQL 8.0中，不支持delay。服务器识别但忽略了DELAYED关键字，将插入处理为非延迟插入，并生成一个er_warn_legacy_syntax_convert警告:不再支持insert DELAYED。该语句被转换为INSERT。DELAYED关键字计划在未来的版本中删除。