MySQL Reference

This page arranges the materials related to learning and using MySQL.

MySQL String Functions
- ASCII
- BIN
- BIT_LENGTH
- CHAR
- CHAR_LENGTH
- CHARACTER_LENGTH
- CONCAT
- CONCAT_WS
- ELT
- EXPORT_SET
- FIELD
- FIND_IN_SET
- FORMAT
- FROM_BASE64
- HEX
- INSERT
- INSTR
- LCASE
- LEFT
- LENGTH
- LOCATE
- LOWER
- LPAD
- LTRIM
- MAKE_SET
- MID
- OCT
- OCTET_LENGTH
- ORD
- POSITION
- QUOTE
- REPEAT
- REPLACE
- REVERSE
- RIGHT
- RPAD
- RTRIM
- SOUNDEX
- SPACE
- STRCMP
- SUBSTR
- SUBSTRING
- SUBSTRING_INDEX
- TO_BASE64
- TRIM
- UCASE
- UNHEX
- UPPER
MySQL Math Functions
- ABS
- ACOS
- ASIN
- ATAN
- ATAN2
- CEIL
- CEILING
- CONV
- COS
- COT
- DEGREES
- DIV
- EXP
- FLOOR
- GREATEST
- LEAST
- LN
- LOG
- LOG10
- LOG2
- MOD
- PI
- POW
- POWER
- RADIANS
- RAND
- ROUND
- SIGN
- SIN
- SQRT
- TAN
- TRUNCATE
MySQL Date and Time Functions
- 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
- FROM_DAYS
- FROM_UNIXTIME
- GET_FORMAT
- 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
- TIMESTAMPADD
- TIMESTAMPDIFF
- TO_DAYS
- TO_SECONDS
- UNIX_TIMESTAMP
- UTC_DATE
- UTC_TIME
- UTC_TIMESTAMP
- WEEK
- WEEKDAY
- WEEKOFYEAR
- YEAR
- YEARWEEK
MySQL Regular Expression Functions
MySQL JSON Functions
MySQL Aggregate Functions
- AVG
- BIT_AND
- BIT_OR
- BIT_XOR
- COUNT
- GROUP_CONCAT
- JSON_ARRAYAGG
- JSON_OBJECTAGG
- MAX
- MIN
- STD
- STDDEV
- STDDEV_POP
- STDDEV_SAMP
- SUM
- VAR_POP
- VARIANCE
MySQL Other Functions
- ANY_VALUE
- BIN_TO_UUID
- BINARY
- CAST
- COALESCE
- CONVERT
- DEFAULT
- INET_ATON
- INET_NTOA
- INET6_ATON
- INET6_NTOA
- IS_IPV4
- IS_IPV4_COMPAT
- IS_IPV4_MAPPED
- IS_IPV6
- IS_UUID
- ISNULL
- NAME_CONST
- SLEEP
- UUID
- UUID_SHORT
- UUID_TO_BIN
MySQL Data Types
- BIGINT
- BINARY
- BIT
- BLOB
- BOOLEAN
- CHAR
- DATE
- DATETIME
- DECIMAL
- DOUBLE
- ENUM
- FLOAT
- GEOMETRY
- INT
- INTEGER
- JSON
- LONGTEXT
- MEDIUMINT
- MEDIUMTEXT
- SET
- SMALLINT
- TEXT
- TIME
- TIMESTAMP
- TINYINT
- TINYTEXT
- VARBINARY
- VARCHAR
- YEAR
MySQL Information Functions
- BENCHMARK
- CHARSET
- COERCIBILITY
- COLLATION
- CONNECTION_ID
- CURRENT_ROLE
- CURRENT_USER
- DATABASE
- ICU_VERSION
- LAST_INSERT_ID
- ROLES_GRAPHML
- ROW_COUNT
- SCHEMA
- SESSION_USER
- SYSTEM_USER
- USER
- VERSION
MySQL Window Functions
- CUME_DIST
- DENSE_RANK
- FIRST_VALUE
- LAG
- LAST_VALUE
- LEAD
- NTH_VALUE
- NTILE
- PERCENT_RANK
- RANK
- ROW_NUMBER