UPDATE

UPDATE

update `表名` set `字段名`='赋值'
update `表名` set `字段名`='赋值',`字段名`='赋值' where `字段名`='判断值'
update `表名` set `字段名`='赋值',`字段名`='赋值' where `字段名`!='判断值'
update `表名` set `字段名`='赋值',`字段名`='赋值' where `字段名`<>'判断值'
update `表名` set `字段名`='赋值',`字段名`='赋值' where `字段名`<'判断值'
update `表名` set `字段名`='赋值',`字段名`='赋值' where `字段名`>'判断值'
update `表名` set `字段名`='赋值',`字段名`='赋值' where `字段名` between '判断值' and '判断值'
update `表名` set `字段名`='赋值',`字段名`='赋值' where `字段名`='判断值' and `字段名`='判断值'
update `表名` set `字段名`='赋值',`字段名`='赋值' where `字段名`='判断值' or `字段名`='判断值'