常用数据库的自增字段创建方法汇总

DB2

CREATE TABLE T1
 (
 id INTEGER NOT NULL GENERATEDALWAYSAS IDENTITY(START WITH1 INCREMENT BY 1 MINVALUE 1 NOMAXVALUENOCYCLENOCACHE ORDER ),
 ...
 );

Oracle （需要创建一个SEQUENCE和一个TRIGGER）：

CREATE TABLET1
 (
 id NUMBER ( 10 , 0 ) NOT NULL,
 ...
 );
 CREATE SEQUENCET1_ID_SEQINCREMENTBY 1 START WITH1 NOMAXVALUENOCYCLECACHE 100ORDER ;
 CREATE ORREPLACE TRIGGERINSERT_T1_ID
 BEFORE INSERT ON T1
 REFERENCINGNEW AS newOLD AS old
 FOR EACHROW
 BEGIN 
SELECT T1_ID_SEQ.NEXTVALINTO :new.idFROM DUAL;
 END ;
 /

MySQL

CREATE TABLET1
 (
 id INT NOT NULL AUTO_INCREMENT,
 ...
 );

PostgreSQL

CREATE TABLET1
 (
 idSERIAL NOT NULL ,
 ...
 );

SQL Server

CREATE TABLET1
 (
 id INT NOT NULL IDENTITY,
 ...
 );

Sybase

CREATE TABLET1
 (
 id INT NOT NULL IDENTITY,
 ...
 );

 

转自：http://chengxuetao.iteye.com/blog/1509193