DO

The DO statement executes an SQL expression without returning any result.

Syntax

DO expr [, expr ...]

Parameters

In some scenarios, the DO statement is equivalent to SELECT expr for quick response without returning results.

Examples

Execute an expression without returning any result.

obclient> DO SLEEP(5);

Execute multiple expressions:

obclient> DO @var1 := 10, @var2 := 20, @var3 := @var1 + @var2;

obclient> SELECT @var1, @var2, @var3;

The query result is as follows:

+-------+-------+-------+
| @var1 | @var2 | @var3 |
+-------+-------+-------+
|    10 |    20 |    30 |
+-------+-------+-------+
1 row in set