create trigger TR_A_DIU_VTDU_SERVER
after insert or update or delete on VTDU_SERVER
for each row
begin
IF INSERTING THEN
INSERT INTO DB_NOTIFY (TABLE_NAME, KEY_VALUE, KEY_INFO, ACTION, ACTION_TIME)
VALUES ('vtdu_server', :NEW.SERVER_ID, NULL, 1, SYSDATE());
ELSIF DELETING THEN
set @index_code=(SELECT INDEX_CODE INTO index_code_val FROM SERVER_INFO WHERE SERVER_ID = :OLD.SERVER_ID);
INSERT INTO DB_NOTIFY (TABLE_NAME, KEY_VALUE, KEY_INFO, ACTION, ACTION_TIME)
VALUES ('vtdu_server', :OLD.SERVER_ID,index_code, 2, SYSDATE());
END IF;
end tr_a_diu_vtdu_server;想知道 mysql 里面如何将多种操作写在一个触发器里?不想写多个触发器。只需回答如何在一个触发器里写多种触发操作就好。
别无选择,只能一个一个分开写 insert, update, delete