Posted By

nkm on 09/28/09

Tagged

Viewed 700 times

Favorited by 1 user(s)

/ Published in: MySQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

-- BACKUP, BACKUP, BACKUP!! --
 
DELETE
FROM child_table
WHERE id
NOT IN
(SELECT id FROM parent_table);

Comment:

You need to login to post a comment.