Best data type for storing currency values in a MySQL database

by

Something like Decimal(19,4) usually works pretty well in most cases. You can adjust the scale and precision to fit the needs of the numbers you need to store. Even in SQL Server, I tend not to use “money” as it’s non-standard.

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. How to create a MySQL hierarchical recursive query?
  3. Error related to only_full_group_by when executing a query in MySql
  4. How to reset AUTO_INCREMENT in MySQL
  5. How to declare a variable in MySQL?
  6. MySQL Query GROUP BY day / month / year
  7. MySQL Cannot Add Foreign Key Constraint
  8. Grouping into interval of 5 minutes within a time range
  9. SQL counting all rows instead of counting individual rows
  10. Adding a leading zero to some values in column in MySQL
  11. Using SQL to determine word count stats of a text field
  12. Update one MySQL table with values from another
  13. MySQL JOIN the most recent row only?
  14. How to transpose mysql table rows into columns
  15. MySQL Group By and Sum total value of other column
  16. MySQL incorrect key file for tmp table when making multiple joins
  17. Does the order of conditions in a WHERE clause affect MySQL performance?
  18. Difference between these two joining table approaches?
  19. MySQL query, MAX() + GROUP BY
  20. MySQL export into outfile : CSV escaping chars
  21. Simple Random Samples from a MySQL Sql database
  22. ALTER table – adding AUTOINCREMENT in MySQL
  23. sql like operator on integer
  24. MySQL Select minimum/maximum among two (or more) given values
  25. MySQL – SELECT * INTO OUTFILE LOCAL ?
  26. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  27. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  28. MySQL update statement to store ranking positions
  29. How to convert a varchar column type to date type without losing the dates
  30. MySQL Multiple Joins in one query?

Leave a Comment