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 the default port number of mysql?

589


Is sql and mysql same?

583


How do I install mysql on windows 7?

588


What are the functions used to encrypt and decrypt the data present in mysql?

611


What are the advantages of myisam over innodb?

651






What is use of mysql?

569


Can you tell the difference between $message and $$message?

610


How to create a test table in your mysql server?

577


What is text?

623


What are mysql queries?

572


Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

589


Can not connect to mysql server 10060?

580


Why is it called mysql?

585


What is mysql database extension?

571


List data types in mysql? Explain

548