SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE dle_post (ID INT, TITLE VARCHAR(155)); CREATE TABLE dle_comments (ID INT, POST_ID INT, TITLE VARCHAR(155)); INSERT INTO dle_post VALUES (1, 'post1'), (2, 'post2'); INSERT INTO dle_comments VALUES (1, 1, 'post1 comment 1'), (2, 2, 'post2 comment 1'), (3, 1, 'post1 comment 2'); DELETE FROM dle_post WHERE id = 1; -- DELETE FROM dle_comments WHERE NOT EXISTS (SELECT 1 FROM dle_post WHERE dle_post.id = dle_comments.post_id); SELECT * FROM dle_comments; DELETE dle_comments.* FROM dle_comments LEFT JOIN dle_post ON dle_post.id = dle_comments.post_id WHERE dle_post.id IS NULL; SELECT * FROM dle_comments;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear