DELIMITER |
CREATE TRIGGER insert00
AFTER INSERT
ON guangli999ll.adad
FOR EACH ROW
BEGIN
INSERT INTO guangli999lk.adad SELECT * FROM guangli999ll.adad
WHERE id>(select max(id) from guangli999lk.adad);
END;
|
DELIMITER ;
DELIMITER |
CREATE TRIGGER tg_sync_delete
AFTER DELETE
ON adad
FOR EACH ROW
BEGIN
DELETE FROM adad2 WHERE adad2.id=old.id;
END;
|
DELIMITER ;
DELIMITER |
CREATE TRIGGER tg_sync_update
AFTER UPDATE
ON adad
FOR EACH ROW
BEGIN
DELETE FROM adad2 WHERE adad2.id=OLD.id;
INSERT INTO adad2 SELECT * FROM adad WHERE id = OLD.id;
END;
|
DELIMITER ;
select LAST_INSERT_ID(value+1)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23840457/viewspace-1114587/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
下一篇：
没有了~
请登录后发表评论
登录
全部评论
