SQLite中的除法会返回整数值
sqlite> select totalUsers/totalBids from
(select (select count(*) from Bids) as totalBids ,
(select count(*) from Users) as totalUsers) A;
1
我们能否将结果转换类型以获取除法结果的实际值?
只需要将其中一个数字乘以1.0
:
SELECT something*1.0/total FROM somewhere
这将给你浮点数除法而不是整数除法。
SELECT CAST(field1 AS FLOAT) / field2
如果你想根据文本列更新列:
UPDATE table_with_fields SET real_field=cast(field_with_txt AS real)