小组国内汽车销量分析 数据表清洗与处理部分

张开发
• 2026/4/10 2:35:10 • 15 分钟阅读

最新文章

推荐文章

相关文章

分享文章

小组国内汽车销量分析 数据表清洗与处理部分
UPDATE car2m SET price REPLACE(price, , ); UPDATE car2m SET name REPLACE(name, , ); UPDATE car2m SET price 0 WHERE price 暂无报价; UPDATE car2m SET price CAST(REPLACE(SUBSTRING_INDEX(price, -, 1), 万, ) AS DECIMAL(10, 2)); UPDATE suv2m SET price REPLACE(price, , ); UPDATE suv2m SET name REPLACE(name, , ); UPDATE suv2m SET price 0 WHERE price 暂无报价; UPDATE suv2m SET price CAST(REPLACE(SUBSTRING_INDEX(price, -, 1), 万, ) AS DECIMAL(10, 2)); UPDATE mpv2m SET price REPLACE(price, , ); UPDATE mpv2m SET name REPLACE(name, , ); UPDATE mpv2m SET price 0 WHERE price 暂无报价; UPDATE mpv2m SET price CAST(REPLACE(SUBSTRING_INDEX(price, -, 1), 万, ) AS DECIMAL(10, 2)); UPDATE car_pingfen SET price CAST(REPLACE(SUBSTRING_INDEX(price, -, 1), 万, ) AS DECIMAL(10, 2)); UPDATE cars_like SET price 0 WHERE price 暂无报价; UPDATE cars_like SET price CAST(REPLACE(SUBSTRING_INDEX(price, -, 1), 万, ) AS DECIMAL(10, 2));

更多文章