Mysql 官方文档

Resource

Related

Data Types

Types

Operators

Assignment Operators

  • :=
  • =

Logical Operators

Comparison Operators

  • ^
  • -
  • !=, <>
  • *
  • /
  • &
  • >
  • >>
  • >=
  • <
  • <<
  • <=
  • <=>
  • % or MOD
  • +
  • |
  • ~
  • BETWEEN ... AND ...
  • BINARY
  • CASE
  • DIV
  • IS
  • IS NOT
  • IS NOT NULL
  • IS NULL
  • LIKE
  • NOT BETWEEN ... AND ...
  • NOT LIKE
  • NOT REGEXP
  • REGEXP
  • RLIKE
  • SOUNDS LIKE

String

String Comparison

Regular Expressions

String Functions

  • ASCII()
  • BIN()
  • BIT_LENGTH()
  • CHAR_LENGTH()
  • CHAR()
  • CHARACTER_LENGTH()
  • CONCAT_WS()
  • CONCAT()
  • ELT()
  • EXPORT_SET()
  • FIELD()
  • FIND_IN_SET()
  • FORMAT()
  • HEX()
  • INSERT()
  • INSTR()
  • LCASE()
  • LEFT()
  • LENGTH()
  • LOAD_FILE()
  • LOCATE()
  • LOWER()
  • LPAD()
  • LTRIM()
  • MAKE_SET()
  • MATCH
  • MID()
  • OCTET_LENGTH()
  • ORD()
  • POSITION()
  • QUOTE()
  • REPEAT()
  • REPLACE()
  • REVERSE()
  • RIGHT()
  • RPAD()
  • RTRIM()
  • SOUNDEX()
  • SPACE()
  • SUBSTR()
  • SUBSTRING_INDEX()
  • SUBSTRING()
  • TRIM()
  • UCASE()
  • UNHEX()
  • UPPER()

Numeric

Arithmetic Operators

Mathematical Functions

  • ABS()
  • ACOS()
  • ASIN()
  • ATAN()
  • ATAN2(), ATAN()
  • CEIL()
  • CEILING()
  • CONV()
  • COS()
  • COT()
  • CRC32()
  • DEGREES()
  • EXP()
  • FLOOR()
  • LN()
  • LOG()
  • LOG10()
  • LOG2()
  • MOD()
  • OCT()
  • PI()
  • POW()
  • POWER()
  • RADIANS()
  • RAND()
  • ROUND()
  • SIGN()
  • SIN()
  • SQRT()
  • TAN()
  • TRUNCATE()

Date

Date and Time

Group

GROUP BY Functions

Information

Information Functions

Encrypt

Encryption and Compression

Miscellaneous

Miscellaneous Functions

  • DEFAULT()
  • GET_LOCK()
  • INET_ATON()
  • INET_NTOA()
  • IS_FREE_LOCK()
  • IS_USED_LOCK()
  • MASTER_POS_WAIT()
  • NAME_CONST()
  • RELEASE_LOCK()
  • SLEEP()
  • UUID_SHORT()
  • UUID()
  • VALUES()

Samples

Select Queires