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';