查看: 743|回复: 0

维护btcomic.net的3条语句

[复制链接]
kernel 发表于 2008-10-23 15:47:59 | 显示全部楼层 |阅读模式
delete t from btc_bt_torrents t where t.tid not in (select e.tid from btc_bt_torrents_ext e)

delete e from btc_bt_torrents_ext e where e.tid not in (select t.tid from btc_bt_torrents t)

delete tk from btc_bt_tracker tk where tk.hash not in (select t.hash from btc_bt_torrents t)
游客
请先登录
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

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