Skip to main content

Command Palette

Search for a command to run...

MYSQL where exists

Published
1 min readView as Markdown

MYSQL where exists

select * from h247app_questions a where exists(
    select * from h247app_questions b where b.quest_parent=a.quest_id
) and test_id=10413;

update h247app_questions a set a.quest_intro=a.quest_name where exists(
    select * from h247app_questions b where b.quest_parent=a.quest_id
);

More from this blog

Khang Nguyen

119 posts