Updating Single Column 更新单列

  1. UPDATE customer
  2. SET email = 'first.coustomer@mail.ru'
  3. WHERE customer_id = 1

Updating Multiple Columns 更新多列

UPDATE customer
SET
    email = 'first.coustomer@mail.ru',
    active = 1
WHERE customer_id = 1

Deleting Column Value 删除列值

UPDATE customer
SET email = NULL
WHERE customer_id = 1

Using Subqueries in UPDATE 在更新中使用子查询

UPDATE customer
SET address_id = (
    SELECT address_id
    FROM address
    WHERE address = '1121 Loja Avenue'
)
WHERE customer_id = 1

Updating ALL Rows 更新所有行

UPDATE newCustomer
SET last_update = NULL

Deleting Specific Rows 删除特定行

DELETE FROM customer
WHERE address_id = 1

Deleting ALL Rows 删除所有行

DELETE FROM customer

Using Subqueries in DELETE 在DELETE中使用子查询

DELETE FROM customer
WHERE address_id = (
    SELECT address_id
    FROM address
    WHERE address = '1121 Loja Avenue'
)