Why Does My MySQL UPDATE JOIN Query Return 'Unknown column in 'field list''?

MySQL UPDATE JOIN query error: "Unknown column in field list"

When executing update queries in MySQL, especially UPDATE JOIN operations, you may encounter error code #1054, prompting "Unknown column in field list".

This error usually results from the syntax error in the use of backticks (`), single quotes (') or double quotes ("). In MySQL, backticks are usually used to enclose column names, while single or double quotes is reserved for values ​​

.

In the query provided:

<code class="language-sql">UPDATE MASTER_USER_PROFILE, TRAN_USER_BRANCH
SET MASTER_USER_PROFILE.fellow=`y`
WHERE MASTER_USER_PROFILE.USER_ID = TRAN_USER_BRANCH.USER_ID
AND TRAN_USER_BRANCH.BRANCH_ID = 17</code>

The error occurs because the value 'y' is enclosed in backticks, which MySQL interprets as a reference to a column named 'y'. To resolve this issue, make sure the values ​​are enclosed in single or double quotes and the column names are enclosed in backticks.

The correct syntax should be:

<code class="language-sql">UPDATE MASTER_USER_PROFILE, TRAN_USER_BRANCH
SET MASTER_USER_PROFILE.fellow='y'
WHERE MASTER_USER_PROFILE.USER_ID = TRAN_USER_BRANCH.USER_ID
AND TRAN_USER_BRANCH.BRANCH_ID = 17</code>

By placing the value 'y' in single quotes, the query correctly sets the value of the fellow column in the MASTER_USER_PROFILE table.

The above is the detailed content of Why Does My MySQL UPDATE JOIN Query Return 'Unknown column in 'field list''?. For more information, please follow other related articles on the PHP Chinese website!