Unknown column in field list error in MySQL Update query

Question

I keep getting MySQL error # 1054 while trying to execute this update request:

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 

This is probably a syntax error, but I tried to use the inner join and other changes, but I keep getting the same message:

 Unknown column 'y' in 'field list' 

Answer 1

Try using different quotation marks for "y", since the identifier quote character is the reverse side ("` "). Otherwise, MySQL "thinks" that you are pointing to a column named "y".

See also MySQL 5 Documentation

Answer 2

Include any string that will be passed to the mysql server inside single quotes; eg:.

 $name = "my name" $query = " INSERT INTO mytable VALUES ( 1 , '$name') " 

Note that although the query is enclosed between double quotation marks, you must enclose any string in single quotation marks.

Answer 3

You can check your choice of quotes (use double / single quotes for values, strings, etc. and backreferences for column names).

Since you want to update the master_user_profile table, I would recommend a master_user_profile :

 UPDATE master_user_profile SET master_user_profile.fellow = 'y' WHERE master_user_profile.user_id IN ( SELECT tran_user_branch.user_id FROM tran_user_branch WHERE tran_user_branch.branch_id = 17); 

Answer 4

In my case, this was caused by an invisible trailing space at the end of the column name. Just check if you are really using "y" or "y".

Answer 5

While working on building a .Net application using EF code, I received this error message when I tried to apply my migration, where I had Sql("UPDATE tableName SET columnName = value"); expression.

Turns out I spelled columnName incorrectly.

Answer 6

A query like thi will also throw an error

 select table1.id from table2 

If the table is listed in the select column and is not included in the from clause.

Answer 7

I got the same error too, the problem is in my case, I included the column name in the GROUP BY , and this caused this error. So I removed the column from the GROUP BY and it worked !!!

Answer 8

If it is sleep mode and JPA. check the name of your specified table and the columns may not match