HEXAQ : A friendly question - answer site for IT professionals

What is the basic difference between Integer, Float & Decimal Data types in MySQL?


0

I am developing my website using MySQL. There will be millions of records (I am not joking)

To store these records in a table, which data type I should use as primary key.

I want to know the difference between Integer, Float & Decimal Data types in MySQL.

Â
asked
 


≡ Total 1 Answer

0

I've put together a short summary about each of them for you. Simply A general rule of thumb is Float values are a good for scientific Calculations, but shouldn't be used for Monetary Values. But for Business Oriented Math, always use Decimal.

http://www.guideushow.com/mysql/the-basic-difference-between-integer-float-decimal-data-types-in-mysql/

Â
replied


Enter your reply here
Answer Preview:
Viewed: 697 times
Asked on: 7/22/2014
Permalink
Topics in this question
  2
  1
Search Question
Similler Questions