CODEWITHSUNDEEP
mysql
randombits
randombits

Reputation: 48440

MySQL double value out of range

The problem here is obvious, I have a value of 0.0000000000005950183389581887 which is too large to fit into a DOUBLE column using MySQL 5.6.

My question is, what data type should the column be or what can I alter this column to in order to be able to store a number with that precision?

Upvotes: 4

Views: 8680

Answers (1)

juergen d
juergen d

Reputation: 204746

You could use DECIMAL. For instance

DECIMAL(50,30)

where 50 is the total number of decimal places and 30 the number of decimal places after the point.

Upvotes: 5

Related Questions