语句1:
if exists(select * from table1 where id=1)
update table1 set col1='aa'
else
insert into table1 values ('aa')
语句2:
delete from table1 where id=1
insert into table1 values ('aa')
目的是完成同样的事情,请大家分析分析这两种做法,哪个效率更高些?
...全文
925打赏收藏
SQL语句性能比较
有以下两条SQL语句: 语句1: if exists(select * from table1 where id=1) update table1 set col1='aa' else insert into table1 values ('aa') 语句2: delete from table1 where id=1 insert into table1 values ('aa') 目的是完成同样的事情,请大家分析分析这两种做法,哪个效率更高些?