Mysql INSERT INTO错误＃1064 [关闭](Mysql INSERT INTO error #1064 [closed])

Mysql INSERT INTO错误＃1064 [关闭](Mysql INSERT INTO error #1064 [closed])

我得到了这个错误：＃1064 - 你的SQL语法有错误; 检查与MySQL服务器版本对应的手册，以便在'INSERT INTO Especimes（nome_individual，data_de_nascimento）VALUES（'Amalia'，'1'在第7行附近使用正确的语法

在尝试运行时：

INSERT INTO Especimes (nome_individual, data_de_nascimento) VALUES ('Amalia', '15/05/1998');

这是我的表：

CREATE TABLE Especimes ( nome_individual VARCHAR(64), data_de_nascimento VARCHAR(64), PRIMARY KEY(nome_individual) )

I'm getting this erro : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO Especimes (nome_individual, data_de_nascimento) VALUES ('Amalia', '1' at line 7

while trying to run this:

INSERT INTO Especimes (nome_individual, data_de_nascimento) VALUES ('Amalia', '15/05/1998');

Here is my table:

CREATE TABLE Especimes ( nome_individual VARCHAR(64), data_de_nascimento VARCHAR(64), PRIMARY KEY(nome_individual) )

最满意答案

你提供的查询是对的....你有一系列的sql命令吗？ ..检查在此查询之前您是否错过了; 对于上一个命令，例如：

CREATE TABLE Especimes ( nome_individual VARCHAR(64), data_de_nascimento VARCHAR(64), PRIMARY KEY(nome_individual) ) ; /* add this */ INSERT INTO Especimes (nome_individual, data_de_nascimento) VALUES ('Amalia', '15/05/1998');

注意，使用适当的数据会更好。 （日期）而不是varchar ..但不是您的错误的起源

the query you provided is right .... have you a sequence of sql command? .. check if before of this query you have missed the ; for the previous command eg:

CREATE TABLE Especimes ( nome_individual VARCHAR(64), data_de_nascimento VARCHAR(64), PRIMARY KEY(nome_individual) ) ; /* add this */ INSERT INTO Especimes (nome_individual, data_de_nascimento) VALUES ('Amalia', '15/05/1998');

NB the use of proper data is better . (date ) instead of varchar .. but is not the origin of your error