Collections:
SLEEP() - Holding Statement Execution
How to hold the statement execution for some time using the SLEEP() function?
✍: FYIcenter.com
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
2023-12-19, 291🔥, 0💬
Popular Posts:
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...