CREATE TRIGGER trig_cc_update AFTER UPDATE ON word FOR EACH ROW BEGIN INSERT INTO bb(id, name,age) SELECT id, name, age FROM aa WHERE id = OLD.id; END; // |
set id=OLD.id%5; IF id=0 INSERT INTO bb(id, name,age) SELECT id, name, age FROM aa0 WHERE id = OLD.id; ELSEIF id=1 INSERT INTO bb(id, name,age) SELECT id, name, age FROM aa1 WHERE id = OLD.id; ... ENDIF; ENDIF; |
原帖由 truemyself 于 2008-2-14 16:39 发表
set id=OLD.id%5;
IF id=0
INSERT INTO bb(id, name,age) SELECT id, name, age FROM aa0 WHERE id = OLD.id;
ELSEIF id=1
INSERT INTO bb(id, name,age) SELECT id, name, age FROM aa1 WHERE id = OLD.id ...
欢迎光临 Chinaunix (http://bbs.chinaunix.net/) | Powered by Discuz! X3.2 |