go create trigger name on [table]after delete as begin --定义游标，使你逐个往下找个ID，并执行update修改 declare flag int select flag=ID from deleted declare [cursorname]cursor for select ID from [table]where ID>@flag open [cursorname]fetch next from [cursorname]update [table]se...
我想在mysql中用触发器修改主键ID ；的值
use
[你的数据库]
go
create
trigger
name
on
[table]
after
delete
as
begin
--定义游标，使你逐个往下找个ID，并执行update修改
declare
@flag
int
select
@flag=ID
from
deleted
declare
[cursorname]
cursor
for
select
ID
from
[table]
where
ID>@flag
open
[cursorname]
fetch
next
from
[cursorname]
update
[table]
set
ID=ID+1
where
ID=fetch
next
from
[cursorname]
WHILE
@@FETCH_STATUS
=
0
begin
update
[table]
set
ID=ID+1
where
ID=fetch
next
from
[cursorname]
close
[cursorname]
DEALLOCATE
authors_cursor
end
end2019-06-07
