MySQL 语句

UPDATE `wttz` SET `扶贫区划码`=substr(`普查系统建档立卡户编码`,1,12) WHERE 1;
UPDATE `任务` r  join `wttz`  w  ON   r.`扶贫区划码`=w.`扶贫区划码` set w.`shy`=r.`手机号码`;
UPDATE `任务` r  join `wttz`  w  ON   r.`扶贫区划码`=w.`扶贫区划码` set w.`审核员姓名`=r.`姓名`;


UPDATE `wttz` SET `核改状态`="正在核实" WHERE 1;

UPDATE `任务` r  join `wttz`  w  ON   r.`扶贫区划码`=w.`扶贫区划码` set w.`手机号码`=r.`手机号码`;
UPDATE `任务` r  join `wttz`  w  ON   r.`姓名`=w.`普查员姓名` set w.`手机号码`=r.`手机号码`;
UPDATE `任务` r  join `wttz`  w  ON   r.`姓名`=w.`普查指导员姓名` set w.`手机号码`=r.`手机号码`;

UPDATE `wttz` SET `地州`=`推送时间` WHERE 1;
UPDATE `wttz` SET `审核`= 0 WHERE 1;


UPDATE `任务` r  join `wttz`  w  ON   r.`扶贫区划码`=w.`扶贫区划码` set w.`shy`=r.`手机号码`;
UPDATE `任务` r  join `wttz`  w  ON   r.`扶贫区划码`=w.`扶贫区划码` set w.`审核员姓名`=r.`姓名`;

UPDATE `任务` r  join `wttz`  w  ON   r.`姓名`=w.`普查员姓名` set w.`sjh`=r.`手机号码`;
UPDATE `任务` r  join `wttz`  w  ON   r.`姓名`=w.`普查指导员姓名` set w.`sjh`=r.`手机号码`;


UPDATE `wttz` SET `清单名称`="系统比对" WHERE `idd`="";

UPDATE `wttz` SET `mddc`="底册无此人" WHERE `mddc`="0";

mddc
UPDATE `任务` r  join `wttz`  w  ON   r.`手机号码`=w.`推送时间` set w.`dz`=r.`手机号码`;
UPDATE `任务` r  join `wttz`  w  ON   r.`手机号码`=w.`推送时间` set w.`州审核员`=r.`姓名`;

SELECT `审核员姓名`,count(*) as `正在核实` FROM `wttz` WHERE `核改状态`="正在核实" group by `审核员姓名`
UPDATE `wttz` SET `扶贫区划码`=substr(`普查系统建档立卡户编码`,1,12) WHERE 1
OK  审核员
UPDATE `任务` r  join `wttz`  w  ON   r.`扶贫区划码`=w.r.`扶贫区划码` set w.`手机号码`=r.`手机号码`

Ok 普查员
UPDATE `任务` r  join `wttz`  w  ON   r.`姓名`=w.`普查员姓名` set w.`手机号码`=r.`手机号码`

Ok指导员
UPDATE `任务` r  join `wttz`  w  ON   r.`姓名`=w.`普查指导员姓名` set w.`手机号码`=r.`手机号码`

Udate `任务` r  join `wttz`  w  on   r.`姓名`=w.substr(`普查系统建档立卡户编码`,1,12) set w.`手机号码`=r.`手机号码`