droptriggerifexists tgr_example;createtrigger test.tgr_example
before updateon test.table1
for each rowbeginif OLD.views_count < NEW.views_count thenupdate test.
用触发器实现2个表字段值的同步更新drop trigger if exists tgr_example;create trigger test.tgr_example before update on test.table1 for each rowbegin if OLD.views_count < NEW.views_count then ...