storing money amounts in mysql

by

Do not store money values as float, use the DECIMAL or NUMERIC type:

Documentation for MySQL Numeric Types

EDIT & clarification:

Float values are vulnerable to rounding errors are they have limited precision so unless you do not care that you only get 9.99 instead of 10.00 you should use DECIMAL/NUMERIC as they are fixed point numbers which do not have such problems.

More Related Contents:

  1. Best data type to store money values in MySQL
  2. What MySQL data type should be used for Latitude/Longitude with 8 decimal places?
  3. MySQL floating point comparison issues
  4. get first occurrence of last changed value of a column [closed]
  5. ROW_NUMBER() in MySQL
  6. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. Creating a “Numbers Table” in MySQL
  9. MYSQL Select MAX Date inside a join statement
  10. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  11. Determine which MySQL configuration file is being used
  12. Rails, MySQL and Snow Leopard
  13. In SQL, how to select the top 2 rows for each group
  14. MySQL CONVERT_TZ()
  15. TRIGGERs that cause INSERTs to fail? Possible?
  16. Mysql query to dynamically convert rows to columns on the basis of two columns
  17. MySQL: #126 – Incorrect key file for table
  18. How to integrate Apache Spark with MySQL for reading database tables as a spark dataframe? [closed]
  19. How to set a MySQL row to READ-ONLY?
  20. Finding number position in string
  21. Why does MySQL autoincrement increase on failed inserts?
  22. Case Sensitive collation in MySQL
  23. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  24. error code 1292 incorrect date value mysql
  25. How to search for rows containing a substring?
  26. Import CSV to Update only one column in table
  27. Error in MySQL library for Node.js
  28. How to import large sql file in phpmyadmin
  29. How to figure out size of Indexes in MySQL
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment