Operators and functions

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