?????????????

??????????????????Z???????????????????????????????????????????????????int????????????????????????????

???????


SELECT * from sheet1 where LENGTH(F_PHONE)!=11 ???????????11?f

DELETE from sheet1 where LENGTH(F_PHONE)!=11 ???????????11?f

select * from sheet1 GROUP BY F_PHONE HAVING COUNT(*)>1 ???????????

select * FROM sheet1 WHERE F_BABY_BIRTHDAY=''????????????????????

UPDATE sheet1 SET F_BABY_BIRTHDAY='19000101' WHERE F_BABY_BIRTHDAY='' ????????????????????????????

SELECT b.* FROM sheet1 a,t_cus_info b  WHERE a.f_phone=b.f_phone?????????????????????????????????

UPDATE sheet1 a,t_cus_info b SET b.F_CUS_INTEGRAL=a.F_CUS_INTEGRAL WHERE b.f_phone=a.f_phone      ??????????????????????????????????????g????????

DELETE a FROM sheet1 a,t_cus_info b WHERE b.f_phone=a.f_phone ???????????????????????????????


??????????????????????????

UPDATE t_cus_info SET F_BABY_BIRTHDAY='' WHERE F_BABY_BIRTHDAY='19000101' ??????????????????????