Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

13.2.5.3 INSERT DELAYED Statement

INSERT DELAYED ...

TheDELAYED option for theINSERT statement is a MySQL extension to standard SQL. In previous versions of MySQL, it can be used for certain kinds of tables (such asMyISAM), such that when a client usesINSERT 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.

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