找回密码
 立即注册
搜索
查看: 239|回复: 0

时空老数据删除语句

[复制链接]

273

主题

158

回帖

1693

积分

版主

积分
1693

活跃会员宣传达人突出贡献优秀版主

发表于 2026-1-27 09:41:11 | 显示全部楼层 |阅读模式
delete from jxddhz
where djbh in ('JHFZDA10000430','JHZZDA10000420')
delete from jxddmx
where djbh in ('JHFZDA10000430','JHZZDA10000420')

delete from dhtz_hz where djbh in ('DHDZDA10000416')
delete from dhtz_mx where djbh in ('DHDZDA10000416')

delete from jh_djhz where djbh in ('JHGZDA10000424')
delete from jh_djmx where djbh in ('JHGZDA10000424')

delete from jh_rkhz where djbh in ('JHAZDA10000414')
delete from jh_rkmx where djbh in ('JHAZDA10000414')
delete from spls_rk where djbh in ('JHAZDA10000414')

delete from pf_djhz
where djbh in ('XSGZDA10001495','XSGZDA10001496','XSGZDA10001497')
delete from pf_djmx
where djbh in ('XSGZDA10001495','XSGZDA10001496','XSGZDA10001497')

delete from pf_ckhz
where djbh in ('XSAZDA10001493','XSAZDA10001494','XSAZDA10001495')
delete from pf_ckmx
where djbh in ('XSAZDA10001493','XSAZDA10001494','XSAZDA10001495')
delete from spls_ck
where djbh in ('XSAZDA10001493','XSAZDA10001494','XSAZDA10001495')

delete from jzorder_hz_his
where djbh in ('JHGZDA10000424','XSGZDA10001495',
'XSGZDA10001496','XSGZDA10001497')
delete from jzorder_mx_his
where djbh in ('JHGZDA10000424','XSGZDA10001495',
'XSGZDA10001496','XSGZDA10001497')

delete from mxysyf
where djbh in ('JHAZDA10000414','XSAZDA10001493',
'XSAZDA10001494','XSAZDA10001495')
delete from wlzhk
where djbh in ('JHAZDA10000414','XSAZDA10001493',
'XSAZDA10001494','XSAZDA10001495')

delete from fhjld
where djbh in ('FHAZDA10001493','FHAZDA10001494','FHAZDA10001495')
delete from fhjldmx
where djbh in ('FHAZDA10001493','FHAZDA10001494','FHAZDA10001495')

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表