如何在sqlite数据库中创建触发器？

Question

我必须在 SQLite 数据库中创建触发器。

数据库中有 3 个表

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

每当从 < 中删除任何行时code>question 表中，option 和 answer 表中相应的数据也应删除。

我正在尝试使用

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

我收到错误来创建触发器。我应该创建两个不同的触发器来执行此操作还是需要对上述语句进行任何更改？

请告诉我。

谢谢 尼迪

Answer 1

删除第一个 DELETE 语句后的 AND：

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

Answer 2

尝试将“AND”替换为“;”如果您仍然收到错误，请在此处发布错误的文本