update 表名 set 旧值 = 新值 where 条件
UPDATE `players` set `district` = '美国' WHERE `id`=1
一次修改多个属性,用英文逗号隔开即可
update `players` set `district` = '中国',`name` = '芜湖大司马' where `id`= 1
where子句运算符
- 操作符会返回布尔值,可以通过多个条件定位数据
- =
- <>或!=
- <
- >
- <=
- >=
- between…and… 闭合区间
- and 逻辑与
- or 逻辑或
UPDATE `players` set `name`='五香蛋' where `id`>=2 AND `id`<= 4
UPDATE `players` set `password` = 'whwhwrqwrq' WHERE `name` != '五香蛋'
update `players` set `district`='荷兰' where `id` between 2 and 4