Explain the difference between FLOAT, DOUBLE and REAL.

Answer Posted / vibhor

float has 32 bit- show 4 digit after decimal point
double has 64 bit- show 8 digith after decimal point
In short, The float is 32 bit while the double is 64 bit
I prepare job's paper from http://quizplaza.com

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to show table structure mysql?

524


How do I install mysql on windows 10 64 bit?

475


What data structure does mysql use?

586


How to set mysql variable in php?

516


How to get the current date in mysql?

576






How to calculate the difference between two time values?

459


What is pdo in php mysql?

506


What are the different mysql database engines?

535


What do we use to remove duplicate records while fetching a data in mysql ?

521


Which is better sqlite or mysql?

501


How much does mysql enterprise cost?

490


How do I clear the screen in mysql?

527


How can I compare two mysql databases?

493


Is microsoft sql same as mysql?

512


How to Set a root password if there is on root password.

590