SQL UPDATE

UPDATE

-- 单表更新数据

USE sql_hr;

UPDATE student
SET age = 50
WHERE studentno = 'S004';
		    

-- 多表更新数据: 修改员工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;