Explain the difference between FLOAT, DOUBLE and REAL.

Answer Posted / mastan

Float has 4 bytes it display 8 places accuracy and double
has 8 bytes it displays 16 places accuracy.

Is This Answer Correct ?    7 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a trigger? How you can create a trigger in mysql?

487


Can varchar be primary key?

508


How to create and drop view in mysql?

509


Can you tell how many values can set the function of mysql to consider?

523


What is regex in mysql?

535






What does innodb stand for?

531


what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

531


What is prepare statement in mysql?

510


What is row level locking in mysql?

514


How to validate email addresses in mysql?

601


Is there a free version of mysql?

481


Explain the difference between delete and truncate.

541


Is mysql is a programming language?

527


How to delete the repeated records from a table?

506


how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

519