Loading

MySQL Functions

Mysql has many inbuilt functions. Those functions can be used in SQL statements or queries in MySQL.
On the basis of their uses we can categorize them in the following categories and also I am putting some functions related to relevant categories:-
1. MySQL String Function:-
ASCII, CHAR , CHAR_LENGTH, CHARACTER_LENGTH, COERCIBILITY, COLLATION, COMPRESS , CONCAT, CONCAT_WS, ELT , EXPORT_SET , ExtractValue, FIELD, FIND_IN_SET, FORMAT, GROUP_CONCAT , INSERT, INSTR, LCASE, LEFT, LENGTH, LOCATE, LOWER, LPAD, LTRIM, LineString , MAKE_SET , MATCH , MID, MultiLineString, POSITION, REPEAT, REPLACE, REVERSE, RIGHT, RPAD, RTRIM, SPACE, STRCMP,SUBSTR, SUBSTRING, SUBSTRING_INDEX, TRIM, UCASE, UPPER
2. MySQL Numeric or Mathematical Function:- ABS, ACOS, ASIN, ATAN, ATAN2, AVG, CEIL, CEILING, COS, COT, COUNT, CUME_DIST , DEGREES, DIV, EXP, FLOOR, FORMAT , FORMAT_BYTES , GeomCollection, GeometryCollection , GREATEST, LEAST, LN, LOG, LOG10, LOG2, MAX, MIN, MOD, PI, POW, POWER, RADIANS, RAND, ROUND, SIGN, SIN, SQRT, SUM, TAN, TRUNCATE

3. MySQL Date or Time Function:- ADDDATE, ADDTIME, CONVERT_TZ, CURDATE, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURTIME, DATE, DATE_ADD, DATE_FORMAT, DATE_SUB, DATEDIFF, DAY, DAYNAME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, EXTRACT, FORMAT_PICO_TIME , FROM_DAYS, FROM_UNIXTIME , HOUR, LAST_DAY, LOCALTIME, LOCALTIMESTAMP, MAKEDATE, MAKETIME, MICROSECOND, MINUTE, MONTH, MONTHNAME, NOW, PERIOD_ADD, PERIOD_DIFF, QUARTER, SEC_TO_TIME, SECOND, STR_TO_DATE, SUBDATE, SUBTIME, SYSDATE, TIME, TIME_FORMAT, TIME_TO_SEC, TIMEDIFF, TIMESTAMP, TO_DAYS, WEEK, WEEKDAY, WEEKOFYEAR, YEAR, YEARWEEK

4. MySQL Advanced Function:- ANY_VALUE, BENCHMARK, BIN, BIN_TO_UUID, BINARY, BIT_AND, BIT_COUNT, BIT_LENGTH, BIT_OR, BIT_XOR, CAN_ACCESS_COLUMN, CAN_ACCESS_DATABASE, CAN_ACCESS_TABLE, CAN_ACCESS_USER, CAN_ACCESS_VIEW, CASE, CAST, CHARSET, COALESCE, CONNECTION_ID, CONV, CONVERT, CURRENT_ROLE, CURRENT_USER, DATABASE, DEFAULT , DENSE_RANK , FIRST_VALUE , FOUND_ROWS, GET_DD_COLUMN_PRIVILEGES, GET_DD_CREATE_OPTIONS, GET_DD_INDEX_SUB_PART_LENGTH, GET_LOCK , GROUPING, GTID_SUBSET, GTID_SUBTRACT, HEX, ICU_VERSION, IF, IFNULL, IN, INET_ATON, INET_NTOA,INET6_ATON,INET6_NTOA, INTERNAL_AUTO_INCREMENT, INTERNAL_AVG_ROW_LENGTH, INTERVALLAST_INSERT_ID, LAST_VALUE, LEAD, LEAST, LOAD_FILE, MASTER_POS_WAIT. IF, IFNULL, ISNULL, LAST_INSERT_ID, NULLIF, SESSION_USER, SYSTEM_USER, USER, VERSION

5.MySQL Encryption or Compression Function:- AES_DECRYPT, AES_ENCRYPT, CRC32, ENCRYPT, FROM_BASE64 , MD5, OLD_PASSWORD, PASSWORD

 

Share with:


Leave a Reply

Connect with:

z35W7z4v9z8w