Beware of FLOAT and DOUBLE in MySQL
The MySQL FLOAT and DOUBLE data types work pretty much like you might expect of floating point types, except that
- GROUP BY makes a distinction between positive and negative zeros and
- calculations that would produce infinities or NaNs produce NULL.
Written by Joni Salonen
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Mysql
Authors
Related Tags
#mysql
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#