Home >> MySql >> Floating data types in MySql

Floating data types in MySql

The Following floating data types are-

1)-Float(M,D)-A floating point number can not unsigned.

Default range from (10,2)

10 - total number of digits(including decimals)
2 - Number of decimal

2)-Double(M,D)-A double precision floating point number can not unsigned.

Default range from (16,4)

16 - total number of digits(including decimals)
4 - Number of decimal

Post Your Comment

Next Questions
Date and Time data types
String data types
Enum data types
SET data types
Difference between varchar and char
Difference between Tinyint and smallint
Difference between enum and set
Difference between signed and unsigned
What is key
What is super key
What is candidate key
What is primary key
What is unique key
What is foreign key
What is join
What is cross join
What is natural join
What is outer join
What is self join
What is aggregate function
COUNT(*) aggregate function
AVG() aggregate function
MIN() aggregate function
MAX() aggregate function
SUM() aggregate function

Copyright ©2022 coderraj.com. All Rights Reserved.