Functions in MySQL

RAND ()--Returns a random number between 0 and 1

Floor (value)--Rounding down

Ceil (value)--Rounding up

COUNT (Field/*); --When the parameter is a field, the number of records in that field in each group is counted, but NULL is not counted; when the parameter is *, counts all records in each group.

Max (field); --Statistics The maximum value of the field in each group

Min (field); --Statistics The minimum value of the field in each group

AVG (field); --Statistics The average of the field in each group

sum (field); --Statistics of the fields in each group and

Group_concat (field); --string connection of data for a field in a grouped result

Functions in MySQL