mysql update 出错

Question

[SQL]update wp_accountinfo set `pwd`=`asdfgh` where uid=1113;
[Err] 1054 - Unknown column 'asdfgh' in 'field list'

求教怎么更新某个字段。

Answer 1

正确语法

update wp_accountinfo set `pwd`='asdfgh' where uid=1113;

注意

`

符号与

'

符号的区别