sql error: Unknown column in 'field list' on insert [duplicate]

Question

I am trying to insert an entry into a table, using Java, and it returns me an error "Unknown column XX in 'field list'".

For example: I have created a table using this line:

CREATE  TABLE `dbcs`.`born in` (`person` VARCHAR(100) ,`year` INT ,`prob` FLOAT);

the table was created successfully.

when I try to insert something to the table, it shows me the error. for example, the command:

INSERT INTO `dbcs`.`born in` VALUES (`Alanis Morissette`,1974,1.0)

will generate the error:

Unknown column 'Alanis Morissette' in 'field list'

Answer 1

Strings must be wrapped in quotes. You're using ticks which are not correct.

INSERT INTO `dbcs`.`born in` VALUES ('Alanis Morissette',1974,1.0)

Answer 2

use

INSERT INTO dbcs.born in VALUES ('Alanis Morissette',1974,1.0)