多种数据库添加自增主键

-------------------------------------------------------
-- MySql
-------------------------------------------------------

create table Person(
     id int not null auto_increment primary key,
     des varchar(255),
     data blob null
)

-------------------------------------------------------
-- SqlServer
-------------------------------------------------------

create table [Person](
     [id] int not null identity(1,1) primary key,
     [des] varchar(255),
     [data] image null
)

-------------------------------------------------------
-- Sqlite
-------------------------------------------------------

create table Person(
     id integer not null autoincrement primary key,
     des varchar(255),
     data blob null
)

-------------------------------------------------------
-- Oracle
-------------------------------------------------------

create table Person(
     id int not null primary key,
     des varchar(255),
     data blob null
)

create sequence personid_seq increment by 1 start with 1 nocache;

create trigger personid_trigger
     before insert on Person
     for each row
     when (new.id is null)
begin 
     select personid_seq.nextval into :new.id from dual;
end;