内部连接嵌套在内部更新语句SQL [英] Inner Join Nested Inside Update Statement SQL

问题描述

我正在尝试编写一个在update语句中执行内部联接的查询.

I am trying to write a query that performs an inner join within an update statement.

这是我正在使用的当前查询:

Here is the current query I am working with:

UPDATE 
    singulation1.`q096_cq33r08-ds01-n-testtable`
SET 
    visual = t2.visual,
    inspection_status = t2.inspection_status,
    inspector_name = t2.inspector_name
FROM 
    singulation1.`q096_cq33r08-ds01-n-testtable` t1
INNER JOIN 
    singulation1.`q014_bq31t05-dw30-x` t2
ON 
    (t1.print = t2.print AND t1.id3 = t2.id3);

关于MySql的某些内容不喜欢FROM子句.

Something about MySql does not like the FROM clause.

推荐答案

对于更新，请在update子句中指定联接

For updates, you specify the join in the update clause

UPDATE
    singulation1.`q096_cq33r08-ds01-n-testtable` AS t1
    INNER JOIN singulation1.`q014_bq31t05-dw30-x` AS t2
      ON t1.print = t2.print AND t1.id3 = t2.id3
SET
    t1.visual = t2.visual
    t1.inspection_status = t2.inspection_status,
    t1.inspector_name = t2.inspector_name

这篇关于内部连接嵌套在内部更新语句SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！