CREATE TRIGGER insert_cdxx
AFTER INSERT
ON resource_table
FOR EACH ROW
BEGIN
IF (SELECT XH FROM t_jcsjzx_hjkq_jcd WHERE XH = NEW.XH) IS NULL
THEN
INSERT INTO result_table (column01,column02...)
SELECT column01,column02... FROM resource_table
WHERE XH = NEW.XH;
END IF;
END
##########################字段注释#######################################
1.字段含义:
resource_table:发生插入事件的表
result_talbe:要插入数据的表
new:my内置字段,指新增的那条数据
2.此触发器的作用:
当resource_table插入一条数据时,result_talbe也相应的插入一条数据
创建触发器CREATE TRIGGER insert_cdxxAFTER INSERTON resource_tableFOR EACH ROWBEGINIF (SELECT XH FROM t_jcsjzx_hjkq_jcd WHERE XH = NEW.XH) IS NULLTHENINSERT INTO result_table (column01,column02...)SELECT column01,column02... FROM resource_tableWHERE XH