以下に、記載。
CREATE TRIGGER trigger1 BEFORE INSERT ON table1 FOR EACH ROW trigger_stmt
・・・他の方法・・・
DELIMITER $$
CREATE TRIGGER trigger_name BEFORE UPDATE
ON tbl_name FOR EACH ROW
BEGIN
実行するSQL文1;
実行するSQL文2;
...
END;
$$
DELIMITER ;
More than 5 years have passed since last update.
以下に、記載。
CREATE TRIGGER trigger1 BEFORE INSERT ON table1 FOR EACH ROW trigger_stmt
・・・他の方法・・・
DELIMITER $$
CREATE TRIGGER trigger_name BEFORE UPDATE
ON tbl_name FOR EACH ROW
BEGIN
実行するSQL文1;
実行するSQL文2;
...
END;
$$
DELIMITER ;
Register as a new user and use Qiita more conveniently