select * from t1 join t2 on t1.id = t2.id delete t1 from t1 join t2 on t1.id = t2.id 删除使用表链接时需要指定删除的表名,自己老是忘,记录一下