Unknown column in ‘field list’ error on MySQL Update query

by

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 8 Documentation

Please use double-/single quotes for values, strings, etc.
Use backticks for column-names only.

More Related Contents:

  1. Using column alias in WHERE clause of MySQL query produces an error
  2. Unknown Column In Where Clause
  3. Can I reuse a calculated field in a SELECT query?
  4. SQL Query needed for fetch value from Two identical table but not fully identical table
  5. SQL select only rows with max value on a column [duplicate]
  6. How to create a MySQL hierarchical recursive query?
  7. How to reset AUTO_INCREMENT in MySQL
  8. MySQL Query GROUP BY day / month / year
  9. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  10. SQL counting all rows instead of counting individual rows
  11. Using union and order by clause in mysql
  12. Can a table field contain a hyphen?
  13. How do I use on delete cascade in mysql?
  14. Adding a leading zero to some values in column in MySQL
  15. Update one MySQL table with values from another
  16. MySQL JOIN the most recent row only?
  17. MySQL Group By and Sum total value of other column
  18. Search all columns of a table using a single where condition with single keyword in mysql
  19. What does SQL clause “GROUP BY 1” mean?
  20. MySQL: Inner join vs Where [duplicate]
  21. Syntax error when using except in a query
  22. MySQL query, MAX() + GROUP BY
  23. Selecting from two tables with inner join and limit [duplicate]
  24. Why the order of evaluation for expressions involving user variables is undefined?
  25. ALTER table – adding AUTOINCREMENT in MySQL
  26. sql like operator on integer
  27. MySQL – SELECT * INTO OUTFILE LOCAL ?
  28. The best way to remove value from SET field?
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment