Unknown column in field list error on MySQL Update query

Question

I keep getting MySQL error  1054  when trying to perform this update query   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   It s probably some syntax error  but I ve tried using an inner join instead and other alterations  but I keep getting the same message   Unknown column  y  in  field list

User · Answer

Enclose any string to be passed to the mysql server inside single quotes; e.g.:

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

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

User · Answer

Just sharing my experience on this  I was having this same issue  My query was like   select table1 column2 from table1   However  table1 did not have column2 column

User · Answer

A query like this will also cause the error   SELECT table1 id FROM table2   Where the table is specified in column select and not included in the from clause

User · Answer

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

User · Answer

If it is hibernate and JPA  check your referred table name and columns might be a mismatch

User · Answer

In my case  it was caused by an unseen trailing space at the end of the column name  Just check if you really use  y  or  y   instead

User · Answer

Just sharing my experience on this  I was having this same issue  The insert or update statement is correct  And I also checked the encoding   The column does exist  Then  I found out that I was referencing the column in my Trigger   You should also check your trigger see if any script is referencing the column you are having the problem with

User · Answer

Try using different quotes for  y  as the identifier quote character is the backtick            Otherwise MySQL  thinks  that you point to a column named  y    See also MySQL 5 Documentation

User · Answer

You might check your choice of quotes  use double-  single quotes for values  strings  etc and backticks for column-names    Since you only want to update the table master user profile I d recommend a nested query   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

User · Answer

In my case  the Hibernate was looking for columns in a snake case  like create date  while the columns in the DB were in the camel case  e g   createDate  Adding spring    jpa      hibernate        naming    must tell spring jpa hibernate to use the column names as specified  not snake case         physical-strategy  org hibernate boot model naming PhysicalNamingStrategyStandardImpl         implicit-strategy  org hibernate boot model naming ImplicitNamingStrategyLegacyJpaImpl  to the application ymlhelped fix the problem

User · Answer

I got this error when using GroupBy via LINQ on a MySQL database   The problem was that the anonymous object property that was being used by GroupBy did not match the database column name   Fixed by renaming anonymous property name to match the column name    Select f   gt  new       ThisPropertyNameNeedsToMatchYourColumnName   f SomeName     GroupBy t   gt  t ThisPropertyNameNeedsToMatchYourColumnName

User · Answer

While working on a  Net app build with EF code first  I got this error message when trying to apply my migration where I had a Sql  UPDATE tableName SET columnName   value    statement   Turns out I misspelled the columnName

[mysql] Unknown column in 'field list' error on MySQL Update query

Examples related to mysql

Examples related to sql

Examples related to mysql-error-1054