Correct database type for mysql to store values: 0.0 to 1.0
I am adding the priority field to XML sitemap to the datab开发者_JAVA百科ase and was wondering what is the correct database type to store values range from 0.0 to 1.0
You could use DECIMAL(2, 1)
, although that will actually be capable of storing -9.9
to 9.9
.
精彩评论