Explain the difference between FLOAT, DOUBLE and REAL.
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
Can mysql handle big data?
What are the other commands to know the structure of a table using mysql commands except explain command?
What are the method you will follow while sql installing
Why do gaps in sequences occur?
What are the different mysql database engines?
What is the difference between sql and mysql and oracle?
How do you create a new database in mysql?
How to enable or disable a row of a table using MySQL in struts?
SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?
How does mysql store data?
Can I install mysql on mac?
What is a definer?
what is the difference between gui testing and database testing? : Mysql dba
How does mysql clustering work?
What is 'mysqld'?