How To Solve Error 1054 Unknown Column In Field List Manually?

Asked By Tony hant 350 points N/A Posted on - 04/05/2017

I keep getting an error 1054 unknown column in field list in MySQL, when I try to execute the following query:

Insert into employees

values(‘12’, ‘anderson’,’Mumbai’);

The name of the first column in my table is ‘c.catalog_tip13.’ Here is the screenshot of the error:

Answered By Julio E Garcia 0 points N/A #293480

I got the reason behind your error. If the data type of this column is int, I am probably providing you the right solution.

All you have to do is remove the backticks and quotes from the int values.

Try replacing your command with the following:

Insert into employees

values(12, ‘anderson’,’Mumbai’);

I think this will solve the error.

Questions
18

Answers
4

Best Answers
0

How To Resolve Windows Driver Error Code 31 Issue?