mysql의 auto_increment 흉내내기

mysql의 auto_increment 흉내내기

CREATE SEQUENCE SEQ_BOOK

INCREMENT BY 1

START WITH 1

MAXVALUE 9999999999 NOCYCLE ;

INSERT INTO BOOKS(BOOK_ID) VALUES(SEQ_BOOK.NEXTVAL);

삭제할 때는

DROP SEQUENCE SEQ_BOOK;