oracle装转换mysql start with 问题

2025-03-04 11:32:04

推荐回答（1个）

回答1：

--建立序列
create sequence s_emp_id
minvalue 1
maxvalue 99999999999999999999999999
start with 1
increment by 1
cache 20;
--建表
create table t_employee
(id number,
name varchar(20),
salary float,
age number);
--主键
alter table t_employee
add constraint t_employee_id_KEY primary key (ID)
using index ;
--触发器
create or replace trigger TR_employee_ID
before insert on t_employee
for each row
declare
-- local variables here
begin
select s_emp_id.nextval into :new.id from dual;
end TR_employee_ID;