SQL – MySQL LPAD() Function
The MySQL LPAD() function left-pads a string with another string, to achieve a specified length.
SQL – MySQL MAKEDATE() Function
The MySQL MAKEDATE() function creates and returns a date based on a year and a number of days value.
SQL – MySQL MAKETIME() Function
The MySQL MAKETIME() function creates and returns a time based on an hour, minute, and second value.
SQL – MySQL MICROSECOND() Function
The MySQL MICROSECOND() function returns the microsecond part of a time/datetime (from 0 to 999999).
SQL – MySQL MINUTE() Function
The MySQL MINUTE() function returns the minute part of a time/datetime (from 0 to 59).
SQL – MySQL MID() Function
The MySQL MID() function extracts a substring from a string, starting at any position from the beginning or end of the string.
SQL – MySQL MOD() Function
The MySQL MOD() function returns the remainder of a number divided by another number.
SQL – MySQL MONTH() Function
The MySQL MONTH() function returns the month part for a given date (a number from 1 to 12).
SQL – MySQL MONTHNAME() Function
The MySQL MONTHNAME() function returns the name of the month for a given date.
SQL – MySQL NOW() Function
The MySQL NOW() function returns the current date and time as “YYYY-MM-DD HH:MM:SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
SQL – MySQL NULLIF() Function
The MySQL NULLIF() function compares two expressions and returns NULL if they are equal. Otherwise, the first expression is returned.
SQL – MySQL PERIOD_ADD() Function
The MySQL PERIOD_ADD() function adds a specified number of months to a period and will return the result formatted as YYYYMM.
SQL – MySQL PERIOD_DIFF() Function
The MySQL PERIOD_DIFF() function returns the difference between two periods (both periods should be in the same format). The result will be in months.
SQL – MySQL POSITION() Function
The MySQL POSITION() function returns the position of the first occurrence of a case-insensitive substring in a string.
SQL – MySQL POW() Function
The MySQL POW() function returns the value of a number raised to the power of another number.
SQL – MySQL POWER() Function
The MySQL POWER() function returns the value of a number raised to the power of another number.