查找sensor_number中含有空格的所有结果
select * from t_sensor_info where sensor_number like '% '
使用replace函数将空格替换成null
UPDATE t_sensor_info si SET si.sensor_number=REPLACE(si.sensor_number, ' ', '');
查找sensor_number中含有空格的所有结果
select * from t_sensor_info where sensor_number like '% '
使用replace函数将空格替换成null
UPDATE t_sensor_info si SET si.sensor_number=REPLACE(si.sensor_number, ' ', '');