mysql 将指定列的浮点数转化为整数:
update
A
set
B =
cast
(B
as
decimal
(10,0))
-- 或者
update
A
set
B = round(B,0)
例如:update hdcloude01.t_a01_eltable set t_a01_eltable.BatteryDal = round(t_a01_eltable.BatteryDal, 0) where t_a01_eltable.`BatteryDal` is not null;