Search code examples
mysqlmysql-error-1054

MySQL error 1054 (42S22) when using UPDATE

When using the MySQL command line interface, I enter the following command:

UPDATE movies SET Title=Full WHERE ID=6;

I get the following error:

ERROR 1054 (42S22): Unknown column 'Full' in 'field list'

I have verified that I am using the table 'movies' and the column 'Title' exist. Also, there does indeed exist an entry with an ID=6.

What am I doing wrong?

Solution

  • UPDATE movies SET Title="Full" WHERE ID=6; ???