update `user` w
set w.zhipw = (
select zhipw from (
select * from `user`
) as x
where zhipw = 'gala')
set w.zhipw = (
select zhipw from (
select * from `user`
) as x
where zhipw = 'gala')
1 需要先把该表查询出来的记录 存入临时表
2 在查这张临时表
3 把临时表查询出来的复制给需要改的字段
执行语句之前
执行语句之后