PTA 跨年挑战赛2025-2026（java）

-- 更新表字段注释ALTERTABLEproduct_coal_fired_belt_conveyor_paramMODIFYCOLUMNsingle_unit_capacityvarchar(

DEFAULTNULLCOMMENT单机容量MW,MODIFYCOLUMNunit_countvarchar(

DEFAULTNULLCOMMENT台数台,MODIFYCOLUMNunit_typevarchar(

DEFAULTNULLCOMMENT机组类型,MODIFYCOLUMNrated_conveying_capacityvarchar(

DEFAULTNULLCOMMENT额定输送量t/h按范围筛选,MODIFYCOLUMNbelt_widthvarchar(

DEFAULTNULLCOMMENT带宽mm按范围筛选,MODIFYCOLUMNbelt_speedvarchar(

DEFAULTNULLCOMMENT带速m/s,MODIFYCOLUMNconveyor_lengthvarchar(

DEFAULTNULLCOMMENT输送机长度m按范围筛选,MODIFYCOLUMNinclude_beltvarchar(

DEFAULTNULLCOMMENT是否含胶带,MODIFYCOLUMNbeltvarchar(

DEFAULTNULLCOMMENT胶带,MODIFYCOLUMNidler_typevarchar(

DEFAULTNULLCOMMENT托辊类型,MODIFYCOLUMNdeviation_correction_devicevarchar(

DEFAULTNULLCOMMENT调偏装置类型及数量要求,MODIFYCOLUMNhydraulic_couplingvarchar(

DEFAULTNULLCOMMENT液力偶合器,MODIFYCOLUMNprotection_elementvarchar(

DEFAULTNULLCOMMENT保护元件,MODIFYCOLUMNvulcanizing_machine_repair_machinevarchar(

DEFAULTNULLCOMMENT硫化机、修补机,MODIFYCOLUMNinclude_guide_chutevarchar(

DEFAULTNULLCOMMENT是否包含导料槽,MODIFYCOLUMNinclude_belt_changing_devicevarchar(

DEFAULTNULLCOMMENT是否包含换带装置,MODIFYCOLUMNinclude_return_belt_cleanervarchar(

DEFAULTNULLCOMMENT是否包含回程带清扫器,MODIFYCOLUMNinclude_belt_break_catchervarchar(

DEFAULTNULLCOMMENT是否包含断带抓捕装置,MODIFYCOLUMNinclude_open_flame_coal_devicevarchar(

DEFAULTNULLCOMMENT是否包含明火煤装置,MODIFYCOLUMNinclude_plow_unloadervarchar(

DEFAULTNULLCOMMENT是否包含犁式卸料器,MODIFYCOLUMNinclude_three_station_telescopic_devicevarchar(

DEFAULTNULLCOMMENT是否包含三工位伸缩装置,MODIFYCOLUMNproject_info_idbigint(

DEFAULTNULLCOMMENT宽表ID,MODIFYCOLUMNbidder_idvarchar(

DEFAULTNULLCOMMENT投标人ID,MODIFYCOLUMNbiddervarchar(

DEFAULTNULLCOMMENT投标人,MODIFYCOLUMNpassed_initial_evaluationvarchar(

DEFAULTNULLCOMMENT是否通过初评,MODIFYCOLUMNperformance_special_qualification_reviewvarchar(

DEFAULTNULLCOMMENT业绩-专项资格初步评审情况对应专项资格条件要求,MODIFYCOLUMNqualification_special_qualification_reviewvarchar(

DEFAULTNULLCOMMENT资质-专项资格初步评审情况对应专项资格条件要求,MODIFYCOLUMNpersonnel_special_qualification_reviewvarchar(

DEFAULTNULLCOMMENT人员-专项资格初步评审情况对应专项资格条件要求,MODIFYCOLUMNother_special_qualification_reviewvarchar(

DEFAULTNULLCOMMENT其他-专项资格初步评审情况对应专项资格条件要求,MODIFYCOLUMNis_win_bidvarchar(

DEFAULTNULLCOMMENT是否中标,MODIFYCOLUMNwin_bid_amountvarchar(

DEFAULTNULLCOMMENT中标金额元;-- 替换表字段值单位为空格UPDATEproduct_coal_fired_belt_conveyor_paramSET--

单机容量去除MW先去空格再替换最后再去空格single_unit_capacityTRIM(REPLACE(TRIM(single_unit_capacity),MW,)),--

台数去除“台”unit_countTRIM(REPLACE(TRIM(unit_count),台,)),--

额定输送量去除t/hrated_conveying_capacityTRIM(REPLACE(TRIM(rated_conveying_capacity),t/h,)),--

带宽去除mmbelt_widthTRIM(REPLACE(TRIM(belt_width),mm,)),--

带速去除m/sbelt_speedTRIM(REPLACE(TRIM(belt_speed),m/s,)),--

输送机长度去除mconveyor_lengthTRIM(REPLACE(TRIM(conveyor_length),m,)),--

中标金额去除“元”和“万元”嵌套REPLACE替代REGEXP_REPLACEwin_bid_amountTRIM(REPLACE(TRIM(REPLACE(TRIM(win_bid_amount),万元,)),元,))-- 去掉WHERE条件直接更新全表空值/无单位的字段TRIM后不变不影响数据;

芒果浏览器-APP下载bb://cc/eb0h5hIQo71iHehzf-芒果浏览器-APP下载应用