Error Unknown column in field list error on MySQL Update query

541 Asked by DanPeters in Python , Asked on Apr 23, 2021

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'

Why getting mysql unknown column in field list ?

Answered by Clare Matthews

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.

Hope it helps!

Error Unknown column in field list error on MySQL Update query

Your Answer