这样创建触发器 那错了? 在线等
以下操作都是通过程序连接执行的, 没有实际的意义
只想建立一个最简单的触发器
#表
CREATE TABLE films3 (
code CHARACTER(5),
title CHARACTER VARYING(40),
did DECIMAL(3),
date_prod DATE,
kind CHAR(10)
);
create TRIGGER FILMS3_BEFORE_INSERT_ROW
before insert on films3 for each row
begin
NULL;
end;
insert into films3 ( CODE, TITLE, DID ) values ( 'ss112','tss1s21',192 ) ;
错误为
trigger 'SYSTEM.FILMS3_BEFORE_INSERT_ROW' is invalid and failed re-validation