Explain the difference between FLOAT, DOUBLE and REAL.

Answer Posted / latha

float is a data type which stores floating values after
the .it takes maximum of 10 bis and it has 4bytes of memory
but in the double it has 8 bytes of memory nd it stores 15
digits after the .(point).

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which mysql function is used to concatenate string?

1060


What is full text indexing in mysql?

702


What is a tinyint?

713


What is key in mysql?

664


How we can get distinct columns values in mysql?

794


Which datatype is used for email in mysql?

702


What is mysql good for?

652


What is the difference between a heap table and temporary table?

688


What is mysql57?

688


How do I stop a query in mysql workbench?

668


How do I run a query in mysql?

705


what is mysql optimization in brief?

2125


What is view in mysql?

746


What are the differences between a primary key and foreign key?

793


can you tell the order of sql select statement? : Mysql dba

660