MySQL Forums
Forum List  »  Newbie

Error Code: 1054. Unknown column 'godofredo' in 'field list'
Posted by: Marcus Soares Djarks
Date: October 12, 2018 11:09AM

Hello! I need some help here! Just downloaded MySQL 8.0 and instal in my OS 10.14. Trying to start to study and understand this new world to me but got sucked in the very beginning! Check it out please:

create table tabela (
coluna1 int,
coluna2 varchar (30),
coluna3 date
);

when I try to insert some data:

insert into tabela
(coluna1, coluna2, coluna3)
values
(`3`, `godofredo`, `1982-01-13`);

and then:

Error Code: 1054. Unknown column '3' in 'field list'

JUST DONT UNDERSTAND WHY! All the questions and answers are so more specific that I couldn't get one for my question!!!

THANKS!!

Options: ReplyQuote


Subject
Written By
Posted
Error Code: 1054. Unknown column 'godofredo' in 'field list'
October 12, 2018 11:09AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.