SQL SELETE

SELECT

Syntax

UPDATE [LOW_PRIORITY] [IGNORE] table_reference
  [PARTITION (partition_list)]
  [FOR PORTION OF period FROM expr1 TO expr2]
  SET col1={expr1|DEFAULT} [,col2={expr2|DEFAULT}] ...
  [WHERE where_condition]
  [ORDER BY ...]
  [LIMIT row_count]
		    

Examples

-- 单表更新数据

USE sql_hr;

UPDATE employees
SET job_title = "VP Marketing"
WHERE employee_id = 76196;
		    

-- 多表更新数据: 修改员工ID为63196所在部门城市为NY

USE sql_hr;

UPDATE offices
INNER JOIN employees ON offices.office_id = employees.office_id
SET offices.city = "NY"
WHERE employees.employee_id = 63196;