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 is field in mysql?

453


What is cursor in mysql?

478


Is mysql written in c?

477


What is the use of mysql workbench?

508


Can mysql function return a table?

593






Where is the mysql config file?

455


Can you tell which of the following where clauses is faster?

434


How many sql dml commands are supported by 'mysql'?

463


How do I stop a mysql command?

473


List data types in mysql? Explain

464


Where is mysql data stored?

471


How can you filter the duplicate data while retrieving records from the table?

462


Does mysql need a server?

474


What is the purpose of using timestamp data type?

492


1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

1543