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

What is truncate command?

450


Can we store images in mysql database?

472


What are procedures in mysql?

485


What is the purpose of using a heap table?

525


Why mongodb is faster than mysql?

467






What is offset limit?

484


What is blob and clob?

507


How to see table's field formats or description of table .

446


How can you count the total number of records of any table?

503


What is root password?

473


What is delimiter in mysql?

472


What is unique key in mysql?

507


How do you connect MySQL database with PHP?

528


What is a simple query?

464


Why do we use views instead of tables?

492