DELETE n from news n LEFT JOIN news2 d ON n.id=d.id WHERE d.id IS null 转载于:https://www.cnblogs.com/macil/p/8603251.html