1.批量update，一条记录update一次，性能很差 update test_tbl set dr='2' where id=1; 2.replace into 或者insert into ...on duplicate key update replace into test_tbl (id,dr) values (1,'2'),(2,'3'),...(x,'y'); 或者使用 insert
最近有用到mysql批量更新，使用最原始的批量update发现性能很差，将网上看到的总结一下一共有以下三种办法：
1.批量update，一条记录update一次，性能很差
update test_tbl set dr='2' where id=1;
2.replace into 或者insert into ...on duplicate key update
replace i
表ks_pscjjlb：表:ks_pscjjlb_temp现在根据ks_pscjjlb_temp表来根据ks_pscjjlb表中的cj字段的值update ks_pscjjlb p1 set p1.cj=(select cj from ks_pscjjlb_temp p2 where p1.id=p2.id )where exists(select 1 from ks_pscjjlb_temp p
select * from [LPicture] UPDATE [dbo].[LPicture] SET [picGroup] = '3213' WHERE LPictureid in(1,2); select * from LPicture where LPictureid not in ('') select * from LPicture where LPictureid n...
如下代码，怎样写成一句，或中间用什么字符隔开才能同时运行？update Yao_Article set Author='/1/35/' where Author='山东 - 历下' update Yao_Article set Author='/1/36/' where Author='山东 - 市中' update Yao_Article set Author='/1/37/' where Author='山东 - 槐荫' update Yao_Article set Author='/1
