为solr数据更新创建trigger

DELIMITER |
 
CREATE TRIGGER messageinsert AFTER INSERT ON message
  FOR EACH ROW BEGIN
      INSERT INTO solrmonitor set mid= NEW.mid,flag=0;
  END
|
 
DELIMITER ;

DELIMITER |
 
CREATE TRIGGER messageupdate AFTER UPDATE ON message
  FOR EACH ROW BEGIN
      INSERT IGNORE INTO solrmonitor set mid= NEW.mid;
      UPDATE solrmonitor set last_modified = now(),flag=0 where mid= NEW.mid;
  END
|
 
DELIMITER ;


DELIMITER |
 
CREATE TRIGGER messagedelete AFTER DELETE ON message
  FOR EACH ROW BEGIN
      INSERT IGNORE INTO solrmonitor set mid= OLD.mid,flag=1;
      UPDATE solrmonitor set last_modified = now(),flag=1 where mid= OLD.mid;
  END
|
 
DELIMITER ;

 

转载于:https://www.cnblogs.com/learnthenknow/p/3670790.html