henriqueelias

Eu estava carregando uns dados em um banco de dados estava tudo carrgando normalmente ate um momento que da o seguinte erro ERROR 1136 (21S01): Column count doesn't match value count at row 1 alguém sabe o que esse erro pode ser?

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?