如果数据处理的时候不需要那么高的精度就不用非要纠结了。看这里help data_types
片段
floats have about 7 digits of accuracy; the magnitude of the number does not matter. Thus, 1234567 can be
stored perfectly as a float, as can 1234567e+20. The number 123456789, however, would be rounded to
123456792. In general, this rounding does not matter.
If you are storing identification numbers, the rounding could matter. If the identification numbers are
integers and take 9 digits or less, store them as longs; otherwise, store them as doubles. doubles have 16
digits of accuracy.