How to store decimal in MySQL?

by

The first parameter of the DECIMAL declaration is the total digits. You probably want to use DECIMAL (4, 2). This allows for up to two digits before the decimal and two after.

Documentation: https://dev.mysql.com/doc/refman/5.7/en/precision-math-decimal-characteristics.html

More Related Contents:

  1. Delete the entire content of all table in a Database [closed]
  2. MyISAM versus InnoDB [closed]
  3. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  4. MySQL string replace
  5. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  6. How do I find the MySQL my.cnf location
  7. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  8. MySQL select one column DISTINCT, with corresponding other columns
  9. How to use mysql JOIN without ON condition?
  10. How to remove all non-alpha numeric characters from a string in MySQL?
  11. Define a variable within select and use it within the same select
  12. ERROR: Error 1005: Can’t create table (errno: 121)
  13. Mysql Convert Column to row (Pivot table )
  14. Merge two tables in one SQL query and make the date values unique
  15. mySQL subquery limit
  16. How to get all columns’ names for all the tables in MySQL?
  17. How do I get MySQL to use an INDEX for view query?
  18. Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
  19. Greatest value of multiple columns with column name?
  20. insert data from one table to another in mysql
  21. libmysqlclient15-dev on macs?
  22. I keep getting this mysql error code #1089
  23. How to drop all tables from the database with manage.py CLI in Django?
  24. How to close sqlalchemy connection in MySQL
  25. How to sort a MYSQL table in a permanent way?
  26. How can I achieve initcap functionality in MySQL?
  27. MySQL errorno 121
  28. Array data type, split string,
  29. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?
  30. How can I make a table in MySQL called “order”?

Leave a Comment