如果是5.0.1x以上的版本可以用触发器
DELIMITER ;;
CREATE TRIGGER `trigger_insTBHedgeSynchronizationOne` AFTER INSERT ON `TBHedgeSynchronizationOne` FOR EACH ROW
BEGIN
REPLACE INTO TBHedgeSynchronization VALUES (new.ID);
end ;;DELIMITER ;
DELIMITER ;;
CREATE TRIGGER `trigger_insTBHedgeSynchronizationOne` AFTER INSERT ON `TBHedgeSynchronizationOne` FOR EACH ROW
BEGIN
REPLACE INTO TBHedgeSynchronization VALUES (new.ID);
end ;;DELIMITER ;
如果是5.0.1x以上的版本可以用触发器
DELIMITER ;;
CREATE TRIGGER `trigger_insTBHedgeSynchronizationOne` AFTER UPDATE ON `TBHedgeSynchronizationOne` FOR EACH ROW
BEGIN
REPLACE INTO TBHedgeSynchronization VALUES (new.ID);
end ;;DELIMITER ;