Collections:
NAME_CONST() - PS Thread ID of Given Connect
How to provide a column name for a constant in a SELECT statement using the NAME_CONST() function?
✍: FYIcenter.com
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
2023-12-19, 257🔥, 0💬
Popular Posts:
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...