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 a heap table?

474


What does mysql_query return?

494


What is blob and clob?

504


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

469


Which mysql function is used to concatenate string?

766






Why is mysql used?

515


write a command to view the content of the table

490


What is unsigned int in mysql?

486


Can we join 3 tables in mysql?

477


What is the date format in mysql?

448


How do I clear the command in mysql?

489


How to find second highest salary from a table?

534


How large can a mysql database become?

475


What is triggers?

510


Is mysql deprecated?

457