Delete Orphaned Records - MySQL Snipplr Social Repository

Revision: 18306

at September 28, 2009 05:46 by nkm

Initial Code

-- BACKUP, BACKUP, BACKUP!! --

DELETE
FROM child_table
WHERE id
NOT IN
(SELECT id FROM parent_table);

Initial URL

http://answers.yahoo.com/question/index?qid=20080708150528AAU33rq

Initial Description

Initial Title

Delete Orphaned Records

Initial Tags

mysql

Initial Language

MySQL