1、多表更新
UPDATE table_references
SET col_name1={exper1 | DEFAULT}
[,col_name2={exper2 | DEFAULT}...]
[WHERE where_condition]
2、references
table_references
{[INNER | CROSS] JOIN | {LEFT | RIGHT} [OUTER] JOIN}
table_references
ON conditional_expt //连接条件
3、连接类型
INNER JOIN 内连接
LEFT [OUTER] JOIN 左外连接
RIGHT [OUTER] JOIN 右外连接
在MySQL 中,JOIN ,CROSS JOIN和INNER JOIN 是等价的。s
eg: UPDATE tdb_goods INNER JOIN tdb_goods_cates ON goods_cate = cate_name
SET goods_cate=cate_id;