DOUBLE vs DECIMAL in MySQL

by

Actually it’s quite different. DOUBLE causes rounding issues. And if you do something like 0.1 + 0.2 it gives you something like 0.30000000000000004. I personally would not trust financial data that uses floating point math. The impact may be small, but who knows. I would rather have what I know is reliable data than data that were approximated, especially when you are dealing with money values.

More Related Contents:

  1. MySQL pagination without double-querying?
  2. Format number to 2 decimal places
  3. CAST to DECIMAL in MySQL
  4. SQL Query needed for fetch value from Two identical table but not fully identical table
  5. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  6. MySQL: Insert record if not exists in table [duplicate]
  7. MySQL Query GROUP BY day / month / year
  8. How do I escape special characters in MySQL?
  9. Enable remote MySQL connection: ERROR 1045 (28000): Access denied for user
  10. SQL counting all rows instead of counting individual rows
  11. MySQL – ERROR 1045 – Access denied
  12. Remote Connections Mysql Ubuntu
  13. MySQL InnoDB not releasing disk space after deleting data rows from table
  14. In MySQL, should I quote numbers or not?
  15. Dump all tables in CSV format using ‘mysqldump’
  16. MySQL add days to a date
  17. How can I loop through all rows of a table? (MySQL)
  18. MySQL Order before Group by
  19. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  20. Export a MySQL Database to SQLite Database
  21. How to display open transactions in MySQL
  22. SQL search multiple values in same field
  23. Removing duplicates with unique index
  24. MySQL – Select the last inserted row easiest way
  25. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  26. MySQL query, MAX() + GROUP BY
  27. ALTER table – adding AUTOINCREMENT in MySQL
  28. For homebrew mysql installs, where’s my.cnf?
  29. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment