草庐IT

CORROSION

全部标签

MySQL 查找最接近或完全匹配的值与更改查找列

我有以下几组数据...状态监测位置数据(CML表)+--------+--------------------+--------------------+--------------+------------+--------------------+-------+-----+|CML_ID|POF_COLUMN|CML_TYPE|SAMPLE_VALUE|COMPLIANCE|CORROSION_SEVERITY|LR_LD|POF|+--------+--------------------+--------------------+--------------+--------