character Functions
CONCAT () Character connection
CONCAT_WS () uses the specified delimiter for character connection format () number formatting lower () to convert lowercase letters upper () to uppercase letters to left () to get the character right () to get the character long () to get the string length Lt. RIM () Remove leading spaces RTrim () remove trailing spaces trim () remove leading and trailing spaces substring () string intercept [not] like () Pattern match replace () string substitution
numeric operators and FunctionsCeil () into a rounding div integer division floor () rounding up a full mod to take the remainder (modulo) power () exponentiation () round () rounding truncate () number intercept [not] between ... And ... [NOT] within range [not] in () [No] in list value range is [not] null [no] is empty
Date-time functionsNow () Current date and Time curdate () Current date curtime () Current time date_add () date change DateDiff () Date difference date_format () date formatting
Information FunctionsCONNECTION_ID () connection iddatebase () Current database last_insert_id () Last Insert record ID number user () Current user version ()
Aggregation FunctionsAVG () average count () Count Max () Max min () minimum sum () sum
Cryptographic FunctionsMD5 () Information digest algorithm password () cipher algorithm
Operators and functions