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 sql does mysql use?
What can you do with mysql?
How do I disconnect mysql workbench?
How to create a table index in mysql?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
Why myisam is faster than innodb?
How do I restore a mysql database dump file in linux?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
How to rename an existing column in a table?
What does do in mysql?
What is memory table?
What happens if you no create privilege in a database?
What are the advantages of a procedure?
Write a command with which mysql table can be repaired
How many rows can be inserted in mysql at a time?