update.sql

人事管理系统 人事管理系统

update main
set 
main.name=:name,main.sex=:sex,main.mz=:mz,main.born=:born,
main.jobdate=:jobdate,main.cgdate=:cgdate,main.hunyin=:hunyin,
main.dw_id=:dw_id,main.gw=:gw,main.xueli=:xueli,main.zc=:zc,
main.zm=:zm,main.zm_date=:zm_date,main.LianXi=:LianXi,
main.address=:address,main.idcard=:idcard,main.dangan=:dangan,
main.diannao=:diannao,main.yiliaocard=:yiliaocard,main.yibaocard=:yibaocard,
main.jl=:jl,main.jnpay=:jnpay,main.gw94=:gw94,main.gw96=:gw96,
main.gw2003=:gw2003,main.gsbt=:gsbt,main.jtqk=:jtqk,
main.lgdate=:lgdate,main.txdate=:txdate,main.bl=:bl,
main.starpay=:starpay,main.addpay=:addpay,main.tolpay=:tolpay,
main.ztsd=:ztsd,main.ztny=:ztny,main.jswhy=:jswhy,main.tingxindate=:tingxindate,
main.worklb=:worklb,main.yonggong=:yonggong,main.zt=:zt,main.photo=:photo    
where main_id=:mainid