1根据身份证来生成性别
UPDATE cbf_jtcy SET cyxb = iif(mid(cyzjhm,17,1) Mod 2=0,'2','1');
2根据条件设置常规字段
update cbf
set bz="1"
where cbf.cbfzjhm ="
3更新时间
update cbjyqzdjb
set djsj=#2019-06-12#
4 判断家庭成员与户主年龄差别
SELECT aa.cyxm,aa.cbfbm,mid(aa.cyzjhm,7,4)as cyyear,aa.yhzgx ,
cbf.cbfmc,mid(cbf.cbfzjhm,7,4) as cbfyear,(cyyear-cbfyear) as 相差多少岁 into bb
from aa,cbf where aa.cbfbm=cbf.cbfbm