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, 396🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...