找回密码
 新猫注册
查看: 971|回复: 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)
您需要登录后才可以回帖 登录 | 新猫注册

本版积分规则

手机版|小黑屋|[漫猫]动漫论坛

GMT+8, 2024-7-16 17:32

Powered by Discuz! X3.5

© 2001-2024 Discuz! Team.

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