I have the field field_name with the following type DECIMAL (10, 2). I want to insert a floating-point number in this field. I have the following SQL-query:
我有字段field_name与以下类型DECIMAL（10,2）。我想在此字段中插入一个浮点数。我有以下SQL查询：
UPDATE `table_name` SET `field_name` = "0,20" WHERE `primary_key` = 1;
SELECT `field_name` FROM `table_name` WHERE `primary_key` = 1;
>> 0.00
How do I write a floating-point number?
如何编写浮点数？
3 个解决方案
#1
2
Use a decimal point . instead of a comma ,:
使用小数点。而不是逗号，：
UPDATE table_name SET field_name = 0.20 WHERE primary_key = 1
However, do note that the DECIMAL type is fixed-point, not floating-point.
但请注意，DECIMAL类型是定点的，而不是浮点型。
#2
1
Try this:
尝试这个：
UPDATE `table_name` SET `field_name` = 0.20 WHERE `primary_key` = 1;
#3
0
UPDATE `table_name`
SET `field_name` = 0.20
WHERE `primary_key` = 1;
It is called floating-point-number - so use a point instead of comma. And since it is no string you don't need the quotes around it.
它被称为浮点数 - 所以使用一个点而不是逗号。因为它不是字符串，所以你不需要它周围的引号。
#1
2
Use a decimal point . instead of a comma ,:
使用小数点。而不是逗号，：
UPDATE table_name SET field_name = 0.20 WHERE primary_key = 1
However, do note that the DECIMAL type is fixed-point, not floating-point.
但请注意，DECIMAL类型是定点的，而不是浮点型。
#2
1
Try this:
尝试这个：
UPDATE `table_name` SET `field_name` = 0.20 WHERE `primary_key` = 1;
#3
0
UPDATE `table_name`
SET `field_name` = 0.20
WHERE `primary_key` = 1;
It is called floating-point-number - so use a point instead of comma. And since it is no string you don't need the quotes around it.
它被称为浮点数 - 所以使用一个点而不是逗号。因为它不是字符串，所以你不需要它周围的引号。