vendredi 24 juin 2016
I did error check on DataGrip but the sql file was still generating a syntax error when I try to run it
So I was installing a schema on my MySql database. I error checked the sql script on DataGrip, it shows no syntax error; yet when I runt it the syntax error pop up
ERROR 1064 (42000) at line 54: 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 '.ortholog_seq_a_ix on orthomcl.ortholog(sequence_id_a)' at line 1
The original code is as follow:
CREATE TABLE orthomcl.Ortholog (
SEQUENCE_ID_A VARCHAR(15),
SEQUENCE_ID_B VARCHAR(15),
TAXON_ID_A VARCHAR(15),
TAXON_ID_B VARCHAR(15),
UNNORMALIZED_SCORE DOUBLE,
NORMALIZED_SCORE DOUBLE
);
CREATE INDEX orthomcl.ortholog_seq_a_ix on orthomcl.ortholog(sequence_id_a);
By the way I'm using an ubuntu system.
Inscription à :
Publier les commentaires (Atom)
Aucun commentaire:
Enregistrer un commentaire