Explain the difference between FLOAT, DOUBLE and REAL.
- 14 Answers
- 70297 Views
- Yahoo, I also Faced
- E-Mail Answers
Answer Posted / amith
FLOATs store floating point numbers with 8 place accuracy
and take up 4 bytes.
DOUBLEs store floating point numbers with 16 place accuracy
and take up 8 bytes.
REAL is a synonym of FLOAT for now.
| Is This Answer Correct ? | 191 Yes | 37 No |
Post New Answer View All Answers
What's new in mysql 8?
How to delete a table.
What is bigint in mysql?
What is table level locking in mysql?
Why do we use mysql?
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
How to control the max size of a heap table?
How do I insert an image into mysql workbench?
Is microsoft sql same as mysql?
Is blocked because of many connection errors unblock with mysqladmin flush hosts?
What do we use to remove duplicate records while fetching a data in mysql ?
What is unsigned int in mysql?
How can you find out the version of the installed mysql?
How to display nth highest salary from a table in a mysql query?
What is normalization and list the different types of normalization?
