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

Mysql also has numerical operations, so list the common functions ceil () div () floor () mod () power () round () truncate (), etc., and talk about the MYSQL numeric operator and function usage.

1,ceil

Select ceil () carry one round off

2,div

Select div () integral division

3. Give up the whole.

4the remainder of 4thecond mod

5gravity power power operation

6 round round

7The digital interception of the dint truncate

These are the common digital operations.

The article is from www.huthon.cn.

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.