ERRO DE SINTAXE 1064 (42000) AO UTILIZAR INSERT

[henriqueelias]

Gente..consegui criar uma tabela da seguinte forma:

DROP TABLE IF EXISTS `Structures`;

SET @saved_cs_client = @@character_set_client;

SET character_set_client = utf8;

CREATE TABLE `Structures` (

`id` int(11) NOT NULL auto_increment,

`pdb` char(4) NOT NULL,

`title` text,

`deposition` date default NULL,

`release` date default NULL,

`resolution` float(3,1) default NULL,

`r_factor` float(5,3) default NULL,

`r_free` float(5,3) default NULL,

`exptl` tinytext,

PRIMARY KEY (`id`),

UNIQUE KEY `idx_pdb` (`pdb`)

) ENGINE=MyISAM AUTO_INCREMENT=36967 DEFAULT CHARSET=utf8;

SET character_set_client = @saved_cs_client;

meu problema esta sendo ao inserir os elementos nesta tabela....estou inserindoo desta forma:

Insert into `Structures`(id,pdb,title,deposition,release,resolution,r_factor,r_free,exptl) values ("1", "101M", "SPERM WHALE MYOGLOBIN F46V N-BUTYL ISOCYANIDE AT PH 9.0", "1997-12-13", "1998-04-08", "2.1", "0.157", "0.202", "X-RAY DIFFRACTION" );

Insert into `Structures`(id,pdb,title,deposition,release,resolution,r_factor,r_free,exptl) values ("2", "102L", "HOW AMINO-ACID INSERTIONS ARE ALLOWED IN AN ALPHA-HELIX OF T4 LYSOZYME", "1992-09-29", "1993-10-31", "1.7", "0.000", "0.000", "X-RAY DIFFRACTION" );

Insert into `Structures`(id,pdb,title,deposition,release,resolution,r_factor,r_free,exptl) values ("3", "102M", "SPERM WHALE MYOGLOBIN H64A AQUOMET AT PH 9.0", "1997-12-15", "1998-04-08", "1.8", "0.159", "0.203", "X-RAY DIFFRACTION" );

mas para todas as linhas da o seguinte erro:

ERROR 1064 (42000): 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 'release,resolution,r_factor,r_free,exptl) values ("1", "101M", "SPERM WHALE MYOG' at line 1

ERROR 1064 (42000): 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 'release,resolution,r_factor,r_free,exptl) values ("2", "102L", "HOW AMINO-ACID I' at line 1

ERROR 1064 (42000): 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 'release,resolution,r_factor,r_free,exptl) values ("3", "102M", "SPERM WHALE MYOG' at line 1

Achei estranho proque mesmo os inserts em cada linha separados...

todos apontam erro na primeira linha...:

Insert into `Structures`(id,pdb,title,deposition,release,resolution,r_factor,r_free,exptl) values ("1", "101M", "SPERM WHALE MYOGLOBIN F46V N-BUTYL ISOCYANIDE AT PH 9.0", "1997-12-13", "1998-04-08", "2.1", "0.157", "0.202", "X-RAY DIFFRACTION" );

Alguém tem alguma idéia do que pode estar ocorrendo?

[Marcus Nunes]

Tenta assim:

INSERT INTO Structures VALUES ('1', '101M', 'SPERM WHALE MYOGLOBIN F46V N-BUTYL ISOCYANIDE AT PH 9.0', '1997-12-13', '1998-04-08', '2.1', '0.157', '0.202', 'X-RAY DIFFRACTION');

Utilize aspas simples.

[Denis Courcy]

Oi, 'henriqueelias'

Você definiu release como um nome de campo. Porém release é palavra chave do MySQL. Para usar este nome como nome de campo você deverá escrevê-lo entre crases, assim: `release`