CREATE TRIGGER `mytrig_mytable_insert` AFTER INSERT ON `mytable`
FOR EACH ROW INSERT INTO mydatabase_bak.`mytable`(`id`, `description`, `created`, `modified`)
VALUES (NEW.id,NEW.description,NEW.created,NEW.modified)
2019年5月5日日曜日
mysqlでインサート時のトリガで別にDBにコピる
insert文を別の書き方すると、MariaDBさんに怒られたので一応メモ。
CREATE TRIGGER `mytrig_mytable_insert` AFTER INSERT ON `mytable`
FOR EACH ROW INSERT INTO mydatabase_bak.`mytable`(`id`, `description`, `created`, `modified`)
VALUES (NEW.id,NEW.description,NEW.created,NEW.modified)
CREATE TRIGGER `mytrig_mytable_insert` AFTER INSERT ON `mytable`
FOR EACH ROW INSERT INTO mydatabase_bak.`mytable`(`id`, `description`, `created`, `modified`)
VALUES (NEW.id,NEW.description,NEW.created,NEW.modified)
登録:
投稿 (Atom)