mysql update和select 无法同时工作在同一张表上(优化器?行锁?)
可以这样解决:
update t2 a1 set a1.d=(select d from ((select d from t2 where k23=3) as a2)) where a1.k23=1;
mysql update和select 无法同时工作在同一张表上(优化器?行锁?)
可以这样解决:
update t2 a1 set a1.d=(select d from ((select d from t2 where k23=3) as a2)) where a1.k23=1;