mysql限制小数位,如何使用phpMyAdmin在MySQL中指定小数精度和小数位数

SQL enables MySQL users to allocate a filed in Decimal format with specific Precision and Scale numbers as:

CREATE TABLE test_table

(

test_column DECIMAL(6,4) NOT NULL

);

How can I do this in phpMyAdmin as the field type has only length/value option available there?

解决方案

Decimals can be added to a MySQL database by using the DECIMAL(M,D) data type. This requires 2 arguments.

M is the maximum number of digits, ranging from 1 to 65.

D is the number of decimal places available, ranging from 0 to 30.

Note that with D digits reserved for decimal places, there can be at most M-D digits available for the integer part. So if we use DECIMAL(6,4), the number 45.8239 would be valid, but 456.12 would not.

To use this in phpMyAdmin, you can do the following:

In the Length/Value field type 6,4 without the parentheses.

results in a table structure like this: