NAME_CONST

Syntax

NAME_CONST(name,value)

Purpose

NAME_CONST() returns the specified value. value must be a constant.

The column generated by NAME_CONST() has the given name.

Examples

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

You can obtain the same results as the preceding example by using simple aliasing:

SELECT 101 AS my_id;