你之前的语句太麻烦了，原因是查询为空，update就会失败修改为如下就可以了：update ac20 set aaz001 = (select aaz001 from ac20 where aae140='24') where aae140 = '23'
