mysql命令更新一个字段的值

表名：h5user+------------------------------+--------+------------+----------+-----------+---------+| opid                         | mccode | teacct     | paydate  | querydate | remarks |+------------------------------+--------+------------+----------+-----------+---------+| o_XOw1bJEJhnUSIr7hKl1eqwY2Yw | 000536 | 12345678   | 20170627 | 24        | 备注    |+------------------------------+--------+------------+----------+-----------+---------+//更新h5user表的paydate字段的值为20170727，查询条件为opid ='o_XOw1bJEJhnUSIr7hKl1eqwY2Yw'update h5user set paydate = '20170727' where opid ='o_XOw1bJEJhnUSIr7hKl1eqwY2Yw';