Ir para conteúdo
Fórum Script Brasil

henriqueelias

Membros
  • Total de itens

    2
  • Registro em

  • Última visita

Posts postados por henriqueelias

  1. 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?

×
×
  • Criar Novo...