MYSQL에서 ORACLE SEQUENCE 사용하기 썸네일형 리스트형 MYSQL에서 ORACLE SEQUENCE 사용하기 Table SchemeCREATE TABLE sequences ( name varchar(32), currval BIGINT UNSIGNED ) ENGINE=InnoDB; procedure DELIMITER $$CREATE PROCEDURE `drop_sequence` (IN the_name text)MODIFIES SQL DATADETERMINISTICBEGIN DELETE FROM sequences WHERE name=the_name;END; DELIMITER $$CREATE PROCEDURE `create_sequence`(IN the_name text)MODIFIES SQL DATADETERMINISTICBEGIN DELETE FROM sequences WHERE name=the_name; INS.. 더보기 이전 1 다음