SQL FLOAT Vs DECIMAL Datatype

MySQL offers a variety of data types to its users, including float and decimal data types. Let's have a look at the main differences between the float and decimal data types in MySQL.

SQL DECIMAL Datatype

To hold definite numeric values, DECIMAL data types are used.

This type is also known as "Fixed-Point" or "Exact Value" Types and is typically used when precision points with exact values are required, such as when storing financial data such as item costs.

NUMERIC is executed as DECIMAL in MySQL.

Example: Its type is DECIMAL(4,2), indicating that there are two decimals inside four digits. This number can be stored in it: 66.76 not in 666.74

This type can be queried in the same way as any other numeric field. Here's how to do it:

CREATE TABLE DemoDecimal (
BookName varchar(255)
    BookPrice DECIMAL (4, 2),
   );

INSERT INTO DemoDecimal (BookName,BookPrice) VALUES ('SQL PROGRAMMING',10.05);

SELECT BookName,BookPrice
 FROM
    DemoDecimal;

In above example we cannot store the value Which exceeds the precision and scale specified in the column definition:

Output: The output of above 4 digit example is

SQL FLOAT Datatype

Conflict can result in floating-point numbers being summarised rather than saved as precise values. The internal representation of a SQL statement may not be the same as a floating-point value written in a SQL statement.

Attempts to treat floating-point numbers in correlations as correct may cause problems. They are also affected by the stage of execution conditions.

These flaws have an impact on the FLOAT and DOUBLE data types.

To define columns, variables, and parameters that store floating-point integers, use the SQL Server FLOAT data type.

Numbers with no set decimal place are referred to be floating point.

When working with scientific values, SQL FLOAT is a good option.

Example:

Even if 2.50 is a FLOAT , you may notice that the number isn't exactly recorded in memory as 2.50. Instead, the number output may be 2.499999.

When comparing values with FLOAT, it can be a little challengiang because the internal representation may be inaccurate by one decimal place.

SQL Difference Between DECIMAL And FLOAT Datatype

In below table we discuss the contrast between decimal & float datatype:-