oracle自增长 mysql sequence

mac2022-06-30  86

让oracle实现mysql的风格,自增长:

给oracle增加一个触发器:代码如下:

CREATE OR REPLACE TRIGGER aaa BEFORE INSERT ON Movie FOR EACH ROW

BEGIN

SELECT MovieSeq.NEXTVAL INTO :new.id FROM DUAL;

END aaa;

. RUN;

___________________________________________________________________________

给MySQL增加Sequence管理功能

见:http://www.2cto.com/database/201202/119528.html

 

                                                 

转载于:https://www.cnblogs.com/yanjunwu/archive/2012/09/30/2709146.html

最新回复(0)