MySQL 如何将字符串转换为十进制？

How to convert string into a decimal?

提问by John Woo

I have two strings "0.31" and "0.0076" and they need to be stored in a decimal(10,2) column in MySQL. How do I do this conversion in ruby but not in mysql directly

我有两个字符串“0.31”和“0.0076”，它们需要存储在 MySQL 的小数（10,2）列中。我如何在 ruby​​ 中而不是在 mysql 中直接进行这种转换

回答by John Woo

try using CAST

尝试使用 CAST

SELECT CAST(colName AS DECIMAL(10,2))
FROM tableName

• SQLFiddle Demo

• SQLFiddle 演示

回答by Mudassir Hasan

use MySql conversion functions CAST or CONVERT . Read Here

使用 MySql 转换函数 CAST 或 CONVERT 。在这里阅读

 Select CAST(columnName as DECIMAL(10,2))

                or

 Select CONVERT(columnName,DECIMAL(10,2))

回答by Bajrang

OR you can do the job like

或者你可以做这样的工作

select format(columnname, 0) as formated from tablename  where condition