Shulou(Shulou.com)06/01 Report--

Common operators for MYSQL

1 character function

CONCAT () character connection

CONCAT_WS () uses the specified delimiter for character concatenation

FORMAT () digit format

Convert LOWER () to lowercase letters

Convert UPPER () to uppercase letters

LEFT () gets the left character

RIGHT () gets the right character

LENGTH () gets the string length

LTRIM () removes leading spaces

RTRIM () removes subsequent spaces

TRIM () removes leading and trailing spaces

SUBSTRING () string interception

LIKE () pattern matching

REPLACE () string substitution

2 Numeric operators and functions

CEIL () carry one round off

DIV integer division

FLOOR () rounding off

MOD take remainder or module

POWER () power operation

POUND () is rounded

TRUNCATE () digital interception

3 compare operators and functions

BETWEEN...AND... Within the scope

NOT BETWEEN...AND... Out of range

IN () is within the listed range

NOT IN () is no longer listed

IS NULL is empty

IS NOT NULL is not empty

4 date-time function

NOW () current date and time

CURDATE () current date

CURTIME () current time

DATE_ADD () date change

DATEDIFF () date difference

DATE_FORMAT () date format

5 Information function

CONNECTION_ID () connects to ID

DATEBASE () current database

LAST_INSERT_ID () last inserts the ID number of the record

USER () current user

VERSION () version information

6 aggregate function

Average of AVG ()

COUNT () count

Maximum value of MAX ()

Minimum MIN ()

SUM () summation

7 encryption function

MD5 () Information Summary algorithm

PASSWORD () cryptographic algorithm

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.