Explain the difference between FLOAT, DOUBLE and REAL.

Answer Posted / leena

Float is 8 bytes with 15 digits precision
Double is same as float
Real is 4 bytes with 7 digits precision

Is This Answer Correct ?    13 Yes 63 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is limit in mysql?

445


How to delete a table.

518


What are the advantages/disadvantages of mysql and php?

504


What is database engine in mysql?

493


What is the use of mysqli_fetch_assoc?

492






How can you retrieve a portion of any column value by using a select query?

448


How to insert html code into mysql database using php?

538


What is mysqladmin flush hosts?

504


What is difference between mysql and mysql workbench?

459


How do I download mysql?

480


Where is the mysql data directory?

499


How do you flush privileges?

532


What is the difference between char and varchar in mysql?

508


What is the difference between MyISAM Static and MyISAM Dynamic?

588


How to run a sql statement?

538