MySQL \u3067\u306f\u52d5\u4f5c\u3059\u308b\u306e\u3060\u304c\u3001Oracle\u306b\u79fb\u884c\u3057\u305f\u9014\u7aef\u306b\u30a8\u30e9\u30fc\u3002
\n\u30b7\u30fc\u30b1\u30f3\u30b9\u304c\u7121\u3044\u3068\u306e\u3053\u3068\u3002<\/p>\n
\u3069\u3046\u3084\u3089\u3001MySQL\u306e\u5834\u5408\u306f\u3001\u4e0b\u8a18\u3092\u30c6\u30fc\u30d6\u30eb\u3068\u3057\u3066\u5b9f\u88c5\u3057\u3066\u3082\u52d5\u4f5c\u3059\u308b\u306e\u3060\u304c\u3001Oracle\u3060\u3068\u30b7\u30fc\u30b1\u30f3\u30b9\u3068\u3057\u3066\u4f5c\u6210\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3088\u3046\u3060\u3002<\/p>\n
MySQL\u3060\u3068\u4e0b\u8a18\u3067\u3082\u52d5\u4f5c\u3059\u308b\u3002
\n[sql]
\nCREATE TABLE BATCH_STEP_EXECUTION_SEQ (
\n\tID BIGINT NOT NULL
\n);<\/p>\n
CREATE TABLE BATCH_JOB_EXECUTION_SEQ (
\n\tID BIGINT NOT NULL
\n);<\/p>\n
CREATE TABLE BATCH_JOB_SEQ (
\n\tID BIGINT NOT NULL
\n);<\/p>\n
INSERT INTO BATCH_STEP_EXECUTION_SEQ VALUES(0);
\nINSERT INTO BATCH_JOB_EXECUTION_SEQ VALUES(0);
\nINSERT INTO BATCH_JOB_SEQ VALUES(0);
\n[\/sql]<\/p>\n
Oracle\u3067\u306f\u3001Table\u3067\u306f\u306a\u304f\u3001Sequence\u3092\u5b9a\u7fa9\u3002
\n[sql]
\nCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 CYCLE;
\nCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 CYCLE;
\nCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 CYCLE;
\n[\/sql]<\/p>\n