Hi there! I have a MySQL table that includes the following table column:
percentDegree decimal(3,1) Not NULL Default 0.0
When I try to run an update...
UPDATE tbl_degrees SET percentDegree = '76.9' WHERE dataDate = '2015'
...the 76.9 is entered in the table as 77.0.
I've seen other questions like this on here but it's usually a matter of people not having and decimal places defined or using the INT type. I've also seen a comment that "you can use FLOAT, but that comes with its own problems" but can't seem to find what those problems would be. Also, isn't this exactly the data type you would use decimals for?