MySQL Advanced Function Part-3

CURRENT_USER Function:- CURRENT_USER Function is used for returning MySQL username and hostname. Which MySQL use to authenticate the current clients. Syntax:- CURRENT_USER() Example:- SELECT CURRENT_USER(); Output:- guest@% DATABASE Function:- The DATABASE Function is used for

Continue Reading

MySQL Advanced Function Part-1

ANY_VALUE Function:- ANY_VALUE Function is used for returning any value in the specified column. ANY_VALUE Function is used with GROUP_BY statement. This function suppresses the error when ONLY_FULL_GROUP_BY mode is enabled. Syntax:- ANY_VALUE(column name) Example:-

Continue Reading

MySQL Date Or Time Function Part-5

LOCALTIME Function:- LOCALTIME Function is used for returning the current date and time. Return format will be YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric) Syntax:- LOCALTIME() Example:- SELECT LOCALTIME(); Output:- 2023-02-12 09:37:02 LOCALTIMESTAMP Function:- LOCALTIMESTAMP

Continue Reading