如题所述
BEGINä¸ENDä¹é´çâæ§è¡è¯å¥å表âåæ°è¡¨ç¤ºéè¦æ§è¡çå¤ä¸ªæ§è¡è¯å¥çå
容ãä¸åçæ§è¡è¯å¥ä¹é´ç¨åå·éå¼ã
注æï¼
ä¸è¬æ åµä¸ï¼MySQLé»è®¤æ¯ä»¥â;âä½ä¸ºç»ææ§è¡è¯å¥ãå¨å建触åå¨è¿ç¨ä¸éè¦ç¨å°â;âã为äºè§£å³è¿ä¸ªé®é¢ï¼å¯ä»¥ç¨DELIMITERè¯å¥ãå¦âDELIMITER
&&âï¼å¯ä»¥å°ç»æ符å·åæâ&&âãå½è§¦åå¨å建å®æåï¼å¯ä»¥ç¨å½ä»¤âDELIMITER
;âæ¥å°ç»æ符å·åæâ;âã
å®ä¾
å建ä¸ä¸ªç±DELETE触åå¤ä¸ªæ§è¡è¯å¥ç触åå¨dept_trig2ã
1. å建dept_trig2触åå¨çSQL代ç å¦ä¸ï¼
DELIMITER &&
CREATE TRIGGER dept_trig2 AFTER DELETE
ON department FOR EACH ROW
BEGIN
INSERT INTO trigger_time VALUES('22:30:30');
INSERT INTO trigger_time VALUES('23:50:50');
END
&&
DELIMITER ;
å¨DOSæ示符çªå£ä¸æ¥çå建dept_trig2触åå¨çæä½ææãå¦ä¸å¾æ示ï¼
ä¸å¾ä¸ä»£ç æ§è¡çç»ææ¾ç¤ºï¼è§¦åå¨å建æåã
2. å¨department表ä¸æ§è¡DELETEæä½ãå¦ä¸å¾æ示ï¼
ä¸å¾ä¸ä»£ç æ§è¡çç»ææ¾ç¤ºï¼å é¤æä½æ§è¡æåã
3. å¨department表ä¸æ§è¡DELETEæä½ä»¥åï¼trigger_time表ä¸å°ä¼èªå¨æå ¥ä¸¤æ¡è®°å½ã
注æï¼
ä¸è¬æ åµä¸ï¼MySQLé»è®¤æ¯ä»¥â;âä½ä¸ºç»ææ§è¡è¯å¥ãå¨å建触åå¨è¿ç¨ä¸éè¦ç¨å°â;âã为äºè§£å³è¿ä¸ªé®é¢ï¼å¯ä»¥ç¨DELIMITERè¯å¥ãå¦âDELIMITER
&&âï¼å¯ä»¥å°ç»æ符å·åæâ&&âãå½è§¦åå¨å建å®æåï¼å¯ä»¥ç¨å½ä»¤âDELIMITER
;âæ¥å°ç»æ符å·åæâ;âã
å®ä¾
å建ä¸ä¸ªç±DELETE触åå¤ä¸ªæ§è¡è¯å¥ç触åå¨dept_trig2ã
1. å建dept_trig2触åå¨çSQL代ç å¦ä¸ï¼
DELIMITER &&
CREATE TRIGGER dept_trig2 AFTER DELETE
ON department FOR EACH ROW
BEGIN
INSERT INTO trigger_time VALUES('22:30:30');
INSERT INTO trigger_time VALUES('23:50:50');
END
&&
DELIMITER ;
å¨DOSæ示符çªå£ä¸æ¥çå建dept_trig2触åå¨çæä½ææãå¦ä¸å¾æ示ï¼
ä¸å¾ä¸ä»£ç æ§è¡çç»ææ¾ç¤ºï¼è§¦åå¨å建æåã
2. å¨department表ä¸æ§è¡DELETEæä½ãå¦ä¸å¾æ示ï¼
ä¸å¾ä¸ä»£ç æ§è¡çç»ææ¾ç¤ºï¼å é¤æä½æ§è¡æåã
3. å¨department表ä¸æ§è¡DELETEæä½ä»¥åï¼trigger_time表ä¸å°ä¼èªå¨æå ¥ä¸¤æ¡è®°å½ã
温馨提示:答案为网友推荐,仅供参考
第1个回答 2016-11-08
delimiter //
CREATE TRIGGER test1 after delete ON A FOR EACH ROW
BEGIN
declare fe int;
set fe= OLD.a;
delete from b where b=fe;
insert into c values(fe);
END //本回答被网友采纳
CREATE TRIGGER test1 after delete ON A FOR EACH ROW
BEGIN
declare fe int;
set fe= OLD.a;
delete from b where b=fe;
insert into c values(fe);
END //本回答被网友采纳