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

2025-01-07, 855🔥, 0💬

SCHEMA() - Synonym for DATABASE()
What's the difference between SCHEMA() and DATABASE() functions? SCHEMA() is a synonym for the DATABASE() function. Related MySQL functions: DATABASE() - Name of Current Database SCHEMA() - Synonym for DATABASE() ⇒ SESSION_USER() - Synonym for USER() ⇐ ROW_COUNT() - Affected Rows from Last DML St... 2025-02-16, 1006🔥, 0💬

Removed: DES_DECRYPT() - DES Data Decryption
How to decrypt data with the DES (Data Encryption Standard) algorithm using the DES_DECRYPT() function? DES_DECRYPT(cipher, key) is a MySQL built-in function that decrypts data with the DES (Data Encryption Standard) algorithm. Note that DES_DECRYPT() is no longer supported. It was: Introduced MySQL... 2024-10-14, 971🔥, 0💬

VERSION() - Version Number of MySQL Server
How to obtain the version number of the MySQL server using the VERSION() function? VERSION() is a MySQL built-in function that returns the version number of the MySQL server. For example: SELECT VERSION(); -- +-----------+ -- | VERSION() | -- +-----------+ -- | 8.0.17 | -- +-----------+ SELECT @@ver... 2025-01-07, 938🔥, 0💬

Removed: DES_ENCRYPT() - DES Data Encryption
How to encrypt data with the DES (Data Encryption Standard) algorithm using the DES_ENCRYPT() function? DES_ENCRYPT(clear, key) is a MySQL built-in function that encrypts data with the DES (Data Encryption Standard) algorithm. Note that DES_ENCRYPT() is no longer supported. It was: Introduced MySQL ... 2024-10-14, 905🔥, 0💬

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? 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'); -- +-------------------+ --... 2025-01-07, 856🔥, 0💬

SYSTEM_USER() - Synonym for USER()
What's the difference between SYSTEM_USER() and USER() functions? SYSTEM_USER() is a synonym for the USER() function. Related MySQL functions: USER() - Login Name of Current User SESSION_USER() - Synonym for USER() SYSTEM_USER() - Synonym for USER() CURRENT_USER() - Authentication Name of Current Us... 2025-01-07, 815🔥, 0💬

Removed MySQL Functions
Where to find answers to frequently asked questions about Removed MySQL Built-in Functions? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team about Removed MySQL Built-in Functions: Removed: ENCODE() - Encoding Data with Password Removed: DECODE() - Decodi... 2024-10-14, 796🔥, 0💬

USER() - Login Name of Current User
How to obtain the login name of the current user using the USER() function? USER() is a MySQL built-in function that returns the login name of the current user. Login name is defined as the combination of user name and the client IP address where you logged in from. For example: SELECT USER(); -- +-... 2025-01-07, 795🔥, 0💬

Removed: DECODE() - Decoding Data with Password
How to decode a byte sequence generated from the ENCODE() function using the DECODE() function? DECODE(cipher, pass) is a MySQL built-in function that encodes a byte sequence generated from the ENCODE() function. Note that DECODE() is no longer supported. It was: Introduced MySQL 4.0. Removed in MyS... 2024-10-14, 753🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.