Skip to main content
Version: 2.5

sleep

Description

Delays the execution of an operation for a specified period of time (in seconds) and returns a BOOLEAN value to indicate whether the sleep is completed without interruption. 1 is returned if the sleep is completed without interruption. Otherwise, 0 is returned.

Syntax

BOOLEAN sleep(INT x);

Parameters

x: the duration for which you want to delay the execution of an operation. It must be of the INT type. Unit: seconds. If the input is is NULL, NULL is returned immediately without sleeping.

Return value

Returns a value of the BOOLEAN type.

Examples

select sleep(3);
+----------+
| sleep(3) |
+----------+
| 1 |
+----------+
1 row in set (3.00 sec)

select sleep(NULL);
+-------------+
| sleep(NULL) |
+-------------+
| NULL |
+-------------+
1 row in set (0.00 sec)

Keywords

SLEEP, sleep