mysql double
时间: 2023-10-13 20:24:40 浏览: 43
Double is a data type in MySQL that is used to store floating-point values with double precision. It is also known as double-precision floating-point format. Double is a 64-bit number and can store values from -1.7976931348623157E+308 to 1.7976931348623157E+308.
Double data type is commonly used to store values that require high precision, such as financial data or scientific calculations. It is also used to store large numbers that cannot be represented by other data types, such as integers or decimals.
Here is an example of how to create a table with a double data type column:
```
CREATE TABLE my_table (
id INT PRIMARY KEY,
double_column DOUBLE
);
```
In this example, we created a table with two columns - id and double_column. The double_column is of type double and can store floating-point values with double precision.