//多SQL中导出的触发器语句：DROP TRIGGER IF EXISTS `t_trig`;DELIMITER //CREATE TRIGGER `t_trig` BEFORE INSERT ON `t_goods` FOR EACH ROW beginset NEW.add_date = current_date();INSERT INTO test2 SET a2 = NEW.id;end//DELIMITER ;/************************************************ ************************************************ ************************************************///在删除一个终端调研时触发删除销售体验和竞品分析DELIMITER //CREATE TRIGGER	`delete_assistant_research` BEFORE DELETE ON `tb_assistant_research`FOR EACH ROW beginDELETE FROM `tb_assistant_experience` WHERE `research_id` = old.id;DELETE FROM `tb_assistant_compete_analyse` WHERE `research_id` = old.id;end//DELIMITER;/************************************************ ************************************************ ************************************************///在删除一个竞品商品时， 删除该竞品商品的竞品分析数据DELIMITERCREATE TRIGGER `delete_product` AFTER DELETE ON	`tb_assistant_compete_product`FOR EACH ROW beginDELETE FROM `tb_assistant_compete_analyse` WHERE `product_id` = old.id;endDELIMITER;/************************************************ ************************************************ ************************************************///在删除某一家门店时，删除该门店的巡店和终端调研//本地服务器118所需要的触发器语句DROP TRIGGER IF EXISTS `delete_assistant_store`;DELIMITER //CREATE TRIGGER	`delete_assistant_store` AFTER DELETE ON `tb_assistant_store`FOR EACH ROW beginDELETE FROM `tb_assistant_visitstore` WHERE `store_id` = old.id;DELETE FROM `tb_assistant_research` WHERE `store_id` = old.id;end//DELIMITER;远程服务器:121.199.167.212所导出的触发器DROP TRIGGER IF EXISTS `delete_assistant_store`//CREATE TRIGGER `delete_assistant_store` AFTER DELETE ON `tb_assistant_store` FOR EACH ROW beginDELETE FROM `tb_assistant_visitstore` WHERE `store_id` = old.id;DELETE FROM `tb_assistant_research` WHERE `store_id` = old.id;end///************************************************ ************************************************ ************************************************/在删除某一个流程时，需要删除对应该流程的备注信息sign=1删除巡店 sign=2删除销售体验 sign=3删除竞品分析//以后用标准格式DROP TRIGGER IF EXISTS `delete_assistant_option`;delimiter //CREATE TRIGGER	`delete_assistant_option` AFTER DELETE ON `tb_assistant_option`FOR EACH ROW BEGINIF old.sign=1 THEN  DELETE FROM `tb_assistant_visitstore_message` WHERE `option_id` = old.id;ELSEIF old.sign=2 THEN  DELETE FROM `tb_assistant_experience_message` WHERE `option_id` = old.id;ELSEIF old.sign=3 THEN  DELETE FROM `tb_assistant_compete_analyse_message` WHERE `option_id` = old.id;END IF;END;//delimiter ;标准格式，版主给的delimiter //CREATE TRIGGER testref BEFORE INSERT ON test1  FOR EACH ROW BEGIN    INSERT INTO test2 SET a2 = NEW.a1;    DELETE FROM test3 WHERE a3 = NEW.a1;    UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;  END;//delimiter ;