-- 可能的数据处理
update sheet1 set phoneNumber=TRIM('+86 ' from phoneNumber);
update sheet1 set phoneNumber=TRIM('+86' from phoneNumber);
SELECT * FROM sheet1 WHERE LEFT ( phoneNumber, 1 )= "+";
-- 正式执行
update sheet1 set phoneNumber=NULL WHERE phoneNumber="";
update sheet1 set phoneNumber=concat('+86 ',phoneNumber) WHERE name not in(
SELECT sh.name FROM(
SELECT
name
FROM
sheet1
WHERE
LEFT ( phoneNumber, 1 )= "+"
) sh
);
mysql函数concat使用
最新推荐文章于 2024-07-24 16:10:55 发布