1.语法
1.修改单表的记录★
UPDATE 表名 SET 列=新值,列=新值,.... WHERE 筛选条件;
UPDATE beauty SET phone = '13899888899' WHERE name LIKE '唐%';
UPDATE boys SET boyname='张飞',usercp=10 WHERE id = 2;
2.修改多表的记录【补充】
SQL192语法:
UPDATE 表1 别名,表2 别名
SET 列=值,...
WHERE 连接条件
AND 筛选条件;
SQL199语法:
UPDATE 表1 别名
INNER|LEFT|RIGHT JOIN 表2 别名
ON 连接条件
SET 列=值,...
WHERE 筛选条件;
UPDATE boys bo INNER JOIN beauty b ON bo.id = b.boyfriend_id SET b.phone = '114' WHERE bo.boyName = '张无忌';
UPDATE boys bo RIGHT JOIN beauty b ON bo.id = b.boyfriend_id SET b.bofriend_id = 2 WHERE b.id IS NULL;