Explain the difference between FLOAT, DOUBLE and REAL.

Answer Posted / amith

FLOATs store floating point numbers with 8 place accuracy
and take up 4 bytes.
DOUBLEs store floating point numbers with 16 place accuracy
and take up 8 bytes.
REAL is a synonym of FLOAT for now.

Is This Answer Correct ?    191 Yes 37 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are aggregate functions in mysql?

690


Is blocked because of many connection errors mysql?

449


How can I insert images into a Mysql database?

573


How to store binary data in mysql?

535


What is a transaction? Describe mysql transaction properties.

550






What is the latest version of php and mysql?

686


Is pdo more secure than mysqli?

470


In mysql, what is joins? Explain

541


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

529


How do I kill a mysql query?

457


How do I know if mysql is installed on windows?

487


What you can use regular expression for in mysql?

492


What is the latest mysql version?

481


What does mysql_query return?

508


What is trigger in mysql?

500