sql - Mysql INSERT INTO error #1064 -
i'm getting erro : #1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'insert especimes (nome_individual, data_de_nascimento) values ('amalia', '1' @ line 7
while trying run this:
insert especimes (nome_individual, data_de_nascimento) values ('amalia', '15/05/1998');
here table:
create table especimes ( nome_individual varchar(64), data_de_nascimento varchar(64), primary key(nome_individual) )
the query provided right .... have sequence of sql command? .. check if before of query have missed ; previous command eg:
create table especimes ( nome_individual varchar(64), data_de_nascimento varchar(64), primary key(nome_individual) ) ; /* add */ insert especimes (nome_individual, data_de_nascimento) values ('amalia', '15/05/1998');
nb use of proper data better . (date ) instead of varchar .. not origin of error
Comments
Post a Comment