-- 更新表字段注释ALTERTABLEproduct_coal_fired_belt_conveyor_paramMODIFYCOLUMNsingle_unit_capacityvarchar(30)DEFAULTNULLCOMMENT单机容量MW,MODIFYCOLUMNunit_countvarchar(10)DEFAULTNULLCOMMENT台数台,MODIFYCOLUMNunit_typevarchar(50)DEFAULTNULLCOMMENT机组类型,MODIFYCOLUMNrated_conveying_capacityvarchar(50)DEFAULTNULLCOMMENT额定输送量t/h按范围筛选,MODIFYCOLUMNbelt_widthvarchar(50)DEFAULTNULLCOMMENT带宽mm按范围筛选,MODIFYCOLUMNbelt_speedvarchar(30)DEFAULTNULLCOMMENT带速m/s,MODIFYCOLUMNconveyor_lengthvarchar(50)DEFAULTNULLCOMMENT输送机长度m按范围筛选,MODIFYCOLUMNinclude_beltvarchar(10)DEFAULTNULLCOMMENT是否含胶带,MODIFYCOLUMNbeltvarchar(50)DEFAULTNULLCOMMENT胶带,MODIFYCOLUMNidler_typevarchar(50)DEFAULTNULLCOMMENT托辊类型,MODIFYCOLUMNdeviation_correction_devicevarchar(100)DEFAULTNULLCOMMENT调偏装置类型及数量要求,MODIFYCOLUMNhydraulic_couplingvarchar(50)DEFAULTNULLCOMMENT液力偶合器,MODIFYCOLUMNprotection_elementvarchar(50)DEFAULTNULLCOMMENT保护元件,MODIFYCOLUMNvulcanizing_machine_repair_machinevarchar(50)DEFAULTNULLCOMMENT硫化机、修补机,MODIFYCOLUMNinclude_guide_chutevarchar(10)DEFAULTNULLCOMMENT是否包含导料槽,MODIFYCOLUMNinclude_belt_changing_devicevarchar(10)DEFAULTNULLCOMMENT是否包含换带装置,MODIFYCOLUMNinclude_return_belt_cleanervarchar(10)DEFAULTNULLCOMMENT是否包含回程带清扫器,MODIFYCOLUMNinclude_belt_break_catchervarchar(10)DEFAULTNULLCOMMENT是否包含断带抓捕装置,MODIFYCOLUMNinclude_open_flame_coal_devicevarchar(10)DEFAULTNULLCOMMENT是否包含明火煤装置,MODIFYCOLUMNinclude_plow_unloadervarchar(10)DEFAULTNULLCOMMENT是否包含犁式卸料器,MODIFYCOLUMNinclude_three_station_telescopic_devicevarchar(10)DEFAULTNULLCOMMENT是否包含三工位伸缩装置,MODIFYCOLUMNproject_info_idbigint(20)DEFAULTNULLCOMMENT宽表ID,MODIFYCOLUMNbidder_idvarchar(50)DEFAULTNULLCOMMENT投标人ID,MODIFYCOLUMNbiddervarchar(100)DEFAULTNULLCOMMENT投标人,MODIFYCOLUMNpassed_initial_evaluationvarchar(10)DEFAULTNULLCOMMENT是否通过初评,MODIFYCOLUMNperformance_special_qualification_reviewvarchar(2000)DEFAULTNULLCOMMENT业绩-专项资格初步评审情况对应专项资格条件要求,MODIFYCOLUMNqualification_special_qualification_reviewvarchar(2000)DEFAULTNULLCOMMENT资质-专项资格初步评审情况对应专项资格条件要求,MODIFYCOLUMNpersonnel_special_qualification_reviewvarchar(2000)DEFAULTNULLCOMMENT人员-专项资格初步评审情况对应专项资格条件要求,MODIFYCOLUMNother_special_qualification_reviewvarchar(2000)DEFAULTNULLCOMMENT其他-专项资格初步评审情况对应专项资格条件要求,MODIFYCOLUMNis_win_bidvarchar(10)DEFAULTNULLCOMMENT是否中标,MODIFYCOLUMNwin_bid_amountvarchar(30)DEFAULTNULLCOMMENT中标金额元;-- 替换表字段值单位为空格UPDATEproduct_coal_fired_belt_conveyor_paramSET-- 1. 单机容量去除MW先去空格再替换最后再去空格single_unit_capacityTRIM(REPLACE(TRIM(single_unit_capacity),MW,)),-- 2. 台数去除“台”unit_countTRIM(REPLACE(TRIM(unit_count),台,)),-- 3. 额定输送量去除t/hrated_conveying_capacityTRIM(REPLACE(TRIM(rated_conveying_capacity),t/h,)),-- 4. 带宽去除mmbelt_widthTRIM(REPLACE(TRIM(belt_width),mm,)),-- 5. 带速去除m/sbelt_speedTRIM(REPLACE(TRIM(belt_speed),m/s,)),-- 6. 输送机长度去除mconveyor_lengthTRIM(REPLACE(TRIM(conveyor_length),m,)),-- 7. 中标金额去除“元”和“万元”嵌套REPLACE替代REGEXP_REPLACEwin_bid_amountTRIM(REPLACE(TRIM(REPLACE(TRIM(win_bid_amount),万元,)),元,))-- 去掉WHERE条件直接更新全表空值/无单位的字段TRIM后不变不影响数据;