Explain the difference between FLOAT, DOUBLE and REAL.

Answer Posted / mohamad nazim

double has 64 bit- show 8 digith after decimal point
float has 32 bit- show 4 digit after decimal point

Is This Answer Correct ?    13 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What port is mysql running on?

541


How to enable or disable a row of a table using MySQL in struts?

3663


How do I insert multiple rows in a table?

530


Write a command to list all databases in mysql?

602


What is database clustering in mysql?

556






What is the data source name for mysql?

555


How many rows mysql can handle?

583


What is the difference between float and double?

664


How to represent ENUMs and SETs internally?

742


What is ddl, dml, and dcl?

652


What are the different tables present in MySQL?

662


How do I fix a crashed mysql database?

579


What is memory table?

575


What is pragma autonomous_transaction?

542


How to show all tables with 'mysql'?

601