以下是udpate select 语句的例子,结构与select 比较相似
UPDATE table1
INNER JOIN table2 ON table1.id = table2.fk_id
SET col1 = table2.col1,
col2 = table2.col2
以下是udpate select 语句的例子,结构与select 比较相似
UPDATE table1
INNER JOIN table2 ON table1.id = table2.fk_id
SET col1 = table2.col1,
col2 = table2.col2