多种数据库添加自增主键

来源：互联网发布：网络炒作公司价格编辑：程序博客网时间：2024/06/08 05:47

--------------------------------------------------------- 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;

0 0