CREATE OR REPLACE TRIGGER “BASEINFO”
AFTER insert OR update
ON BASEINFO
FOR EACH ROW
DECLARE
nextseq NUMBER;
BEGIN
select BASEINFO.nextval into nextseq from dual;
CASE
WHEN inserting THEN
INSERT INTO BASEINFO ( ID, STATUS, OP, EX, DATE, S_EXT_TIMESTAMP )
VALUES (nextseq, ‘NEW’, ‘0’, -1, sysdate, :new.S_EXT_TIMESTAMP);
WHEN updating THEN
INSERT INTO BASEINFO ( ID, STATUS, OP, EX, DATE, S_EXT_TIMESTAMP )
VALUES (nextseq, ‘NEW’, ‘1’, -1, sysdate, :new.S_EXT_TIMESTAMP);
END;
如何构建高性能MySQL？
