MySQL Common functions

1. String functions

2. Numeric functions

3. Date function

Date_format (DATE,FMT) function: Format Date value in FMT by string, this function can display the date in the specified format

4. Process functions

Examples are as follows

Mysql> Select if (salary>2000, ' High ', ' low ') from salary;

Mysql> Select Ifnull (salary,0) from salary;

Mysql> Select Case salary when the "low" when the then ' mid ' "Else ' high ' end from salary;

5. Other functions

MySQL Common functions