Difference between float and decimal data type

by

This is what I found when I had this doubt.

mysql> create table numbers (a decimal(10,2), b float);
mysql> insert into numbers values (100, 100);
mysql> select @a := (a/3), @b := (b/3), @a * 3, @b * 3 from numbers \G
*************************** 1. row ***************************
  @a := (a/3): 33.333333333
  @b := (b/3): 33.333333333333
@a + @a + @a: 99.999999999000000000000000000000
@b + @b + @b: 100

The decimal did exactly what’s supposed to do on this cases, it
truncated the rest, thus losing the 1/3 part.

So for sums the decimal is better, but for divisions the float is
better, up to some point, of course. I mean, using DECIMAL will not give
you a “fail proof arithmetic” in any means.

Hope this helps.

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. MySQL – Rows to Columns
  3. ROW_NUMBER() in MySQL
  4. How can I temporarily disable a foreign key constraint in MySQL?
  5. Creating a “Numbers Table” in MySQL
  6. MYSQL Select MAX Date inside a join statement
  7. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  8. Determine which MySQL configuration file is being used
  9. MySQL, better to insert NULL or empty string?
  10. Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How do I grant privileges?
  11. MySQL indexes – what are the best practices?
  12. Selecting random rows with MySQL
  13. JavaFX MySQL connection example please
  14. mysql select int as currency or convert int to currency format?
  15. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  16. Why do results from a SQL query not come back in the order I expect?
  17. MySQL combine two columns and add into a new column
  18. MySql difference between two timestamps in days?
  19. Is there a naming convention for MySQL?
  20. How to integrate Apache Spark with MySQL for reading database tables as a spark dataframe? [closed]
  21. How to set a MySQL row to READ-ONLY?
  22. Finding number position in string
  23. Why does MySQL autoincrement increase on failed inserts?
  24. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  25. error code 1292 incorrect date value mysql
  26. How to search for rows containing a substring?
  27. Import CSV to Update only one column in table
  28. Error in MySQL library for Node.js
  29. Update multiple rows with multiple ‘where’ clauses for each individual row
  30. WHERE datetime older than some time (eg. 15 minutes)

Leave a Comment