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 constraints? Also explain the different types of constraints?
Is mysql a dbms?
How to use regular expression in pattern match conditions?
What are the advantages and disadvantages of using mysql?
What is a join? Explain the different types of mysql joins.
How do I change directories in mysql?
What is a storage engine?
What is the purpose of using a heap table?
How to create a trigger in mysql?
What are the differences between a primary key and foreign key?
What are the non-standard sql commands supported by 'mysql'?
How can you change the password of a mysql user?
Should I use pdo or mysqli?
How do I install mysql workbench?
What is dirty read and phantom read?