Brian Dunning's Error Code Reference

MySQL Error 1054

SQLSTATE: 42S22 (ER_BAD_FIELD_ERROR) Unknown column '%s' in '%s'

 

Comments

Scott   Scott
Nov 4, 2017
This errors appears when trying to INSERT a TEXT value into a field, without placing it inside of inverted commas, 'example'. This does not apply to INTERGER (numbers) values.

E.g. [wrong syntax]
INSERT INTO Customers (firstName)
VALUES (Scott); = ERROR 1054

[Correct syntax]
INSERT INTO Customers (firstName)
VALUES ('Scott');