mysql - 我无法执行触发器中的两条语句

Question

我希望这两个语句都在我的触发器中执行。我无法执行以下操作:

IF (flag = 'D') THEN
BEGIN
     INSERT INTO logs (id, author_id, action_done, description, old_value, new_value, create_date) 
     VALUES (null, (SELECT id FROM gallery WHERE flag = 'D'), 'Delete', 'Gallery', (SELECT filename FROM gallery WHERE flag = 'D'), '', NOW());
     DELETE FROM gallery WHERE flag = 'D';
END
END IF

Answer 1

我假设日志表中的 id 字段是主键并且由系统自动生成。

试试这个:

IF (flag = 'D') THEN
BEGIN
     INSERT INTO logs (author_id, action_done, description, old_value, new_value, create_date) 
     select id, 'Delete', 'Gallery', filename, '', NOW() from gallery where flag='D'; 
     DELETE FROM gallery WHERE flag = 'D';
END
END IF