(1054)Unknown column in 'field list' - Mysql Error

Question

I'm try to update some coloumn's cell in mysql.

when i execute this , value as number:

update tablename set contents=1 where contensid=218;

it is working.

but i execute value as a character:

update tablename set contents=text where contensid=218;

Please try again later or contact an Administrator. (1054)Unknown column 'text' in 'field list'

what i have to do update value as character ??

since `text` is string, you should wrap it with single quote. `contents='text'` — John Woo, Jul 23 '13 at 00:02

score 5 · Accepted Answer · answered Jul 23 '13 at 00:11

5

If you don't put your "text" inside '', query thinks it is a column in your table. So do this:

update tablename set contents='text' where contensid=218;

answered Jul 23 '13 at 00:11

AliBZ

score -1 · Answer 2 · answered Oct 21 '13 at 15:58

-1

Maybe your column is wrong,You will need check the column,and again comit.

answered Oct 21 '13 at 15:58

john

2 Answers2