General MySQL Oracle SQL Server

SLEEP() - Holding Statement Execution

Q

How to hold the statement execution for some time using the SLEEP() function?

✍: FYIcenter.com

A

SLEEP(sec) is a MySQL built-in function that holds the execution of the current statement for sec seconds. For example: 

SELECT SYSDATE(), SLEEP(2), SYSDATE();
  -- +---------------------+----------+---------------------+
  -- | SYSDATE()           | SLEEP(2) | SYSDATE()           |
  -- +---------------------+----------+---------------------+
  -- | 2023-12-16 23:46:02 |        0 | 2023-12-16 23:46:04 |
  -- +---------------------+----------+---------------------+

Reference information of the SLEEP() function: 

SLEEP(sec): boolean
  Holds the execution for sec seconds and returns 0. Returns 1 if interrupted.

Arguments, return value and availability:
  sec: Required. The number of seconds to hold.
  boolean: Return value. 0 if and only if it holds to end.
  Available since MySQL 4.0.

 

⇒ UPDATEXML() - Updating Child Element in XML

⇐ RELEASE_LOCK() - Release Lock Instance

⇑ MySQL Functions for Miscellaneous Purposes

⇑⇑ MySQL Function References

2023-12-19, 1506🔥, 0💬

General MySQL Oracle SQL Server