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
2025-01-07, 472🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Present a Past Time in Hours, Minutes and Seconds in MySQL? If you want show an article was p...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...