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, 304🔥, 0💬
Popular Posts:
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...