mysql: select LAST_INSERT_ID() as id
oracle: sql = "select seq_customer_id.CurrVal from dual";
这是oracle的,因为oracle不会自动生成,创建Customer id 自增触发器,所以用这么写。
--
创建Customer id 序列
create sequence seq_customer_id
minvalue 1
maxvalue 9999999
start with 1
increment by 1 ;
-- 创建Customer id 自增触发器
create or replace trigger customer_id_increment
before insert on customer
referencing
new as new
old as old
for each row
begin
select seq_customer_id.nextval into :new.id from dual;
end ;
create sequence seq_customer_id
minvalue 1
maxvalue 9999999
start with 1
increment by 1 ;
-- 创建Customer id 自增触发器
create or replace trigger customer_id_increment
before insert on customer
referencing
new as new
old as old
for each row
begin
select seq_customer_id.nextval into :new.id from dual;
end ;
sqlserver: select @@identity as id