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

Popular posts from this blog

java - SSE Emitter : Manage timeouts and complete() -

jquery - uncaught exception: DataTables Editor - remote hosting of code not allowed -

java - How to resolve error - package com.squareup.okhttp3 doesn't exist? -