一条条的更新没有问题,但是更新的记录多了,就会出现以下问题,请问该怎么办,谢谢ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction以下是出问题的sql语句,
update emailqueue e set e.body=replace(e.body,'varattention',
(select c.name from customer c where e.to=c.email))
where e.exception like '%body is null%';
update emailqueue e set e.body=replace(e.body,'varattention',
(select c.name from customer c where e.to=c.email))
where e.exception like '%body is null%';
你可以把表提出来
update emailqueue e,customer c set e.body=replace(e.body,'varattention',c.name)
where e.exception like '%body is null%' AND e.to=c.email;