How can I create a trigger in sqlite database?

Question

I have to create trigger in my SQLite database.

There are 3 tables in database

questions (question_id)
options (option_id, question_id)
answers (answer_id, question_id)

Whenever any row is deleted from question table, the corresponding data should also be deleted from option and answer tables.

I am trying to create trigger using

CREATE TRIGGER question_delete
BEFORE DELETE ON questions
FOR EACH ROW BEGIN
DELETE from options WHERE question_id= OLD.question_id AND
DELETE from answers WHERE question_id= OLD.question_id;
END

I get an error. Should I create two different trigger to perform this operation or any changes are required in above statement?

Please let me know.

Thanks Nidhi

WHAT error do you get?? It really doesn't help us to know you get "an error" - but you're not telling us what it is!! — marc_s
– marc_s, Commented May 11, 2011 at 11:45

Alex K. · Accepted Answer · 2011-05-11 12:01:33Z

2

Remove the AND after the first DELETE statement:

DELETE from options WHERE question_id = OLD.question_id;
DELETE from answers WHERE question_id = OLD.question_id;

answered May 11, 2011 at 12:01

Alex K.

177k32 gold badges276 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joel · Accepted Answer · 2011-05-11 12:02:48Z

0

try replacing the "AND" with ";" and it you still get an error, post the error's text here

answered May 11, 2011 at 12:02

Joel

3,4545 gold badges41 silver badges60 bronze badges

Collectives™ on Stack Overflow

How can I create a trigger in sqlite database?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related