MySQL round function

In MySQL, the round function is used for rounding data, which has two forms:

1, round (x,d), x refers to the number to be processed, d refers to the retention of several decimals

One of the notable points here is that D can be a negative number, when the D-bit integer bit to the left of the specified decimal point is 0, and the decimal places are 0;

2, round (x), is actually round (x,0), also is the default d is 0;

Here are a few examples

1, query: Select round (1123.26723,2);

Results: 1123.27

2, query: Select round (1123.26723,1);

Results: 1123.3

3, query: Select round (1123.26723,0);

Results: 1123

4, query: Select round (1123.26723,-1);

Results: 1120

5, query: Select round (1123.26723,-2);

Results: 1100

5, query: Select round (1123.26723);

Results: 1123

MySQL round function