MySQL Common basic operating Syntax (12) ~ ~ Common numeric Functions "command line Mode"

Numeric functions are one of the most commonly used functions, and it is necessary to learn MySQL, which is commonly used as follows:
1. Ceil: Returns the smallest integer value greater than a number:

2. Floor: In contrast to the previous one, returns the maximum integer value less than a certain number:

3. Round: Returns the value after a value is rounded:

For example, the second parameter of round represents the number of decimal digits that need to be preserved.

4. Truncate: Returns the value after a value has been truncated:

Unlike round, the second parameter represents the number of decimal digits that need to be retained, regardless of the number of decimal digits that need to be left behind.

Note: The above examples are integers, but these functions can also handle negative numbers the same way. The numeric functions are more than these, but these few I personally think are more commonly used, so just record these few.

MySQL Common basic operating Syntax (12) ~ ~ Common numeric Functions "command line Mode"