一列
ALTER TABLE cspg_mp_db.mp_device_electric_consumption_statistics_1d MODIFY COLUMN electric double(20,2) NULL COMMENT '电量';
所有列
SELECT CONCAT('ALTER TABLE wangguan MODIFY ',
COLUMN_NAME, ' FLOAT(10,3);')
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'wangguan';