MySQL automatically changes the input decimal point to an integer.

The field type in the database is obviously set to the double type, but when you input a decimal number, the decimal number will become an integer.

The navicat client is used, and there is a "decimal place" in it. I don't know what it is.

Later, when previewing SQL statements, I found'Bank' double (11,0) not null.

After thinkingDouble (11,0) is changedDouble (11,3 ),Sure enough, we can insert decimal places, retain three decimal places, and write 3 on the "decimal place" option.

Understand the meaning of this "decimal place.