Advanced Search

Delete Orphaned Records

/ Published in: MySQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. -- BACKUP, BACKUP, BACKUP!! --
  2.  
  3. DELETE
  4. FROM child_table
  5. WHERE id
  6. NOT IN
  7. (SELECT id FROM parent_table);

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

Report this snippet


Comments

You need to login to view comments.