I have three tables as below (simplified for demonstration):
words ===== integer id text word meanings ======== integer id integer word_id text meaning examples ======== integer id integer meaning_id text sentence
id of the word in
words table and
id of the meaning in
meanings table. I am trying to figure out a sql query, given a word's id, to delete the word with all its meanings and example sentences all at one time. Is such sql query possible to compose? If so, how?
Edit1: I am using SQLite3 as the database.
Edit2: I figured the following solution which requires 3 sql queries in order:
DELETE FROM examples WHERE meaning_id IN (SELECT id FROM meanings WHERE word_id=the_given_id); DELETE FROM meanings WHERE word_id=the_given_id; DELETE FROM words WHERE id=the_given_id;
I'm still looking for the answer to my question: is the whole process possible to be done in one query?