float is float (4bytes) double is double of float ;) (8 bytes) !!

Explain the difference between FLOAT, DOUBLE and REAL.

Question Posted / leelu

Answer Posted / leelu

float is float (4bytes)

double is double of float ;) (8 bytes) !!

Is This Answer Correct ?

52 Yes

52 No

Please Help Members By Posting Answers For Below Questions

How can you find out the version of the installed mysql?

812

Is mysql frontend or backend?

546

What is blob in mysql?

584

How many TRIGGERS are allowed in MySql table?

650

What is the date format in mysql?

539

How to display top 10 rows in mysql?

651

Why mysql is open source?

554

Which storage engine is best in mysql?

564

When to use order by in delete statement?

649

What are numeric data types?

624

What are the steps required to view your mysql database?

704

Can we rename database in mysql?

557

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

671

How many triggers are possible in mysql?

600

What are the three types of queries?

538