NAME_CONST

Syntax

NAME_CONST(name,value)

Purpose

This function returns the specified value. The value parameter should be a constant.

NAME_CONST() specifies the name for the columns in the generated result set.

Examples

obclient> SELECT NAME_CONST('my_id', 101);
+-------+
| my_id |
+-------+
|   101 |
+-------+
1 row in set

You can also achieve the same result by setting a simple alias, as shown below:

SELECT 101 AS my_id;