update.md

# 更新数据

现有 employee 表如下：

```mysql
create table employee
(
    id serial primary key,
    name text,
    dept text,
    salary money
);
```

Joe 希望修改销售部(dept 字段为 sale)员工 Dora Muk 的工资，将其增加 1000。正确的修改语句是：

## 答案

```mysql
update employee set salary = salary + 1000 where dept = 'sale' and name = 'Dora Muk';
```

## 选项

### 过滤条件不严谨

```mysql
update employee set salary = salary + 1000 where name = 'Dora Muk';
```


### 缺少过滤条件

```mysql
update employee set salary = salary + 1000;
```

### 错误的赋值语句

```mysql
update employee set salary += 1000;
```