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
What is save point in mysql?
Why myisam is faster than innodb?
Restore database (or database table) from backup.
Why mongodb is faster than mysql?
How to update a root password.
Can mysql scale horizontally?
How many queries can mysql handle?
How do we delete a row in a table?
What is the role of a limit in a mysql query?
Can you tell the difference between $message and $$message?
How many ways we can retrieve the date in result set of mysql using php?
How to rename an existing table in mysql?
What is localhost in mysql?
What is dump in mysql?
What is session variable in mysql?