General MySQL Oracle SQL Server

NAME_CONST() - PS Thread ID of Given Connect

Q

How to provide a column name for a constant in a SELECT statement using the NAME_CONST() function?

✍: FYIcenter.com

A

NAME_CONST(con) is a MySQL built-in function that provides a column name for a constant in a SELECT statement. For example: 

SELECT NAME_CONST('domain', 'dba.fyicenter.com');
  -- +-------------------+
  -- | domain            |
  -- +-------------------+
  -- | dba.fyicenter.com |
  -- +-------------------+

SELECT NAME_CONST('length', LENGTH('dba.fyicenter.com'));
ERROR 1210 (HY000): Incorrect arguments to NAME_CONST

Reference information of the NAME_CONST() function: 

NAME_CONST(const): name
  Provides a column name for a constant in a SELECT statement.

Arguments, return value and availability:
  const: Required. The constant to be named.
  name: Return value. The column name in the result set.
  Available since MySQL 4.0.

 

⇒ NULLIF() - NULL on Equal Values

⇐ LEAST() - Finding the Least/Minimum Value

⇑ MySQL Functions for Miscellaneous Purposes

⇑⇑ MySQL Function References

2023-12-19, 251🔥, 0💬

General MySQL Oracle SQL Server