Veena Rani, Author at KSH TUTOR

MySQL Advanced Function Part-4

March 2, 2023March 2, 2023 Education, Science And Technology IFNULL, IN, INET6_ATON, INET6_NTOA, INET_ATON, INET_NTOA, ISNULL, LAST_VALUE, LEAD

IFNULL Function:- IFNULL Function is used to check given if expression is NULL. Syntax:- IFNULL(check expression, return value expression) Example:- SELECT IFNULL(NULL, “kshtutor.com”); Output:- kshtutor.com IN Function:- IN Function is used for finding a match

MySQL Advanced Function Part-3

February 28, 2023February 28, 2023 Education, Science And Technology CURRENT_USER, DATABASE, DEFAULT, DENSE_RANK, FIRST_VALUE, FOUND_ROWS, GET_LOCK, GROUPING, GTID_SUBSET, GTID_SUBTRACT, HEX, ICU_VERSION, IF

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

MySQL Advanced Function Part-2

February 26, 2023February 26, 2023 Education, Science And Technology CAN_ACCESS_USER, CAN_ACCESS_VIEW, CASE, CAST, COALESCE, CONNECTION_ID, CONV, CONVERT, CURRENT_ROLE

CAN_ACCESS_USER Function:- CAN_ACCESS_USER Function is used only for internal server operation. CAN_ACCESS_VIEW Function:- CAN_ACCESS_VIEW Function is used only for internal server operation. CASE Function:- CASE Function is used for conditional construct. It works like a

MySQL Advanced Function Part-1

February 23, 2023February 23, 2023 Education, Science And Technology ANY_VALUE, BENCHMARK, BIN, BINARY, BIN_TO_UUID, BIT_AND, BIT_COUNT, BIT_LENGTH, BIT_OR, BIT_XOR, CAN_ACCESS_COLUMN, CAN_ACCESS_DATABASE, CAN_ACCESS_TABLE

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:-

MySQL Date Or Time Function Part-8

February 16, 2023February 16, 2023 Education, Science And Technology TO_DAYS, WEEK, WEEKDAY, WEEKOFYEAR, YEAR, YEARWEEK

TO_DAYS Function:- TO_DAYS Function is used for returning the date between a date and year from 0. It uses the Gregorian calendar dates. Syntax:- TO_DAYS(date) Example:- SELECT TO_DAYS(“2023-02-15”); Output:- 738931 WEEK Function:- WEEK Function is

MySQL Date Or Time Function Part-7

February 15, 2023February 15, 2023 Education, Science And Technology SYSDATE, TIME, TIMEDIFF, TIMESTAMP, TIME_FORMAT, TIME_TO_SEC

SYSDATE Function:- SYSDATE Function is used to return the current server date and time. The format of the date and time will be “YYYY-MM-DD HH:MM: SS” (string) or as YYYYMMDDHHMMSS (numeric). Syntax:- SYSDATE() Example:- SELECT

MySQL Date Or Time Function Part-6

February 14, 2023February 14, 2023 Education, Science And Technology PERIOD_ADD, PERIOD_DIFF, QUARTER, SECOND, SEC_TO_TIME, STR_TO_DATE, SUBDATE, SUBTIME

PERIOD_ADD Function:- PERIOD_ADD Function is used for adding a specific number of months to a period. Its return format will be YYYYMM Syntax:- PERIOD_ADD(period, number) Example:- SELECT PERIOD_ADD(202203, 21); Output:- 202312 PERIOD_DIFF Function:- PERIOD_DIFF Function

MySQL Date Or Time Function Part-5

February 13, 2023February 13, 2023 Education, Science And Technology LOCALTIME.LOCALTIMESTAMP.MAKEDATE.MAKETIME, MICROSECOND, MINUTE, MONTH.MONTHNAME, NOW

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

MySQL Date Or Time Function Part-4

February 12, 2023February 12, 2023 Education, Science And Technology DAYOFWEEK, DAYOFYEAR, EXTRACT, FROM_DAYS, FROM_UNIXTIME, HOUR, LAST_DAY

DAYOFWEEK Function:- DAYOFWEEK Function is used for returning the weekday index from a given day. Weekday index 1 for Sunday, 2 for Monday, 3 for Tuesday, 4 for Wednesday, 5 for Friday, 6 for Saturday,

MySQL Date Or Time Function Part-3

February 10, 2023February 10, 2023 Education, Science And Technology DATEDIFF, DATE_SUB, DAY, DAYNAME, DAYOFMONTH

DATE_SUB Function:- DATE_SUB Function is used for returning the date after subtracting the date or time interval. Syntax:- DATE_SUB(date, INTERVAL value addunit) We can use following add Unit:- MICROSECOND, SECOND, MINUTE, HOUR, DAY, WEEK, MONTH,