use hbposv10 UPDATE t_bd_item_info SET sale_price= CAST(sale_price as decimal(38,1)) UPDATE t_pc_branch_price SET sale_price= CAST(sale_price as decimal(38,1))