22,210
社区成员
发帖
与我相关
我的任务
分享
alter table table1 disable trigger all
update table1 set name=(select name from table1 where id=4) where id=2
alter table table1 enable trigger all
create table td
(id int, name char(1))
-------------
insert into td select
1 ,'A'
insert into td select
2 ,'B'
insert into td select
3 ,'C'
insert into td select
4 ,'D'
update td set name=(select name from td where id=4) where id=2
select * from td
create table tb(id int,name varchar(10))
insert into tb select 1,'A'
insert into tb select 2,'B'
insert into tb select 3,'C'
insert into tb select 4,'D'
update TB set name=(select name from TB where id=4) where id=2
SELECT * FROM TB