DELAYED

DELAYED is an option used in SQL, specifically with the INSERT command to improve the performance of a write-intensive application. It allows the server to return immediately to the client and then insert the row separately. This means that the INSERT DELAYED statement returns as soon as the row has been queued, which can be significantly faster than the normal INSERT statement.

Example

INSERT DELAYED INTO my_table
(name, email)
VALUES ('John Doe', 'john.doe@example.com');

Output

Query OK, 1 row affected (0.00 sec)

Explanation

The DELAYED keyword in the INSERT statement of MySQL is used to queue rows for insertion, and then return immediately, without waiting for the actual insertion. As a result, the query “Query OK, 1 row affected (0.00 sec)” gets displayed, meaning a row has been queued for insertion.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.