根据考生信息初始化库
INSERT INTO t_tdd (ksh,xm,sfzh) SELECT eid,name,cardid FROM examinfo
初始化基它信息
UPDATE t_tdd t,candidate c SET t.XBDM=c.sex,t.CSNY=c.birthday,t.ZZMMDM=c.policy_id,t.MZDM=c.nation_id,
t.KSLBDM=c.etype_id,t.ZXMC=c.mschool,t.DQDM=c.area,t.JTDZ=c.address,
t.YZBM=c.postcode,t.LXDH=c.tel,t.SJR=c.comunitee WHERE t.KSH=c.eid
初始化科类代码
UPDATE t_tdd SET KLDM = 1 WHERE SUBSTRING(KSH FROM 10 FOR 1) IN (1,3,4)
UPDATE t_tdd SET KLDM = 5 WHERE SUBSTRING(KSH FROM 10 FOR 1) IN (5,7,8)
初始化志愿
UPDATE t_tdd t,candidate c SET t.ZYDH1 = c.major1,t.ZYDH2=c.major2,t.ZYDH3=c.major3,t.ZYDH4=c.major4,t.ZYDH5=c.major5,
t.ZYZYTJ=c.isobey WHERE t.KSH=c.eid
志愿处理
UPDATE t_tdd SET ZYDH1 = NULL WHERE ZYDH1=0;
UPDATE t_tdd SET ZYDH2 = NULL WHERE ZYDH2=0;
UPDATE t_tdd SET ZYDH3 = NULL WHERE ZYDH3=0;
UPDATE t_tdd SET ZYDH4 = NULL WHERE ZYDH4=0;
UPDATE t_tdd SET ZYDH5 = NULL WHERE ZYDH5=0;
初始化成绩
UPDATE t_tdd t,cjk j SET t.GKCJX01=j.CJ1,t.GKCJX02=j.CJ2,t.GKCJX03=j.CJ3 WHERE t.KSH=j.KSH;
UPDATE t_tdd SET CJ = GKCJX01+GKCJX02+GKCJX03;
UPDATE t_tdd SET ZYYTJZCJ = CJ;