[BioPython] BioSQL documentation for Biopython

Sebastian Bassi sbassi at gmail.com
Fri Feb 22 23:45:19 UTC 2008


On Fri, Feb 22, 2008 at 1:21 AM, Hilmar Lapp <hlapp at gmx.net> wrote:
>  Could some Biopythonist check this material whether or not it still
>  has any relevance, and whether there are any errors?

I've tried to import the schema (biosqldb-mysql.sql) into my MySQL
server (5.0.45-Debian_1ubuntu3-log) and got this:

Error
SQL query:
-- CONFIG: you may want to add this for mysql because MySQL often is broken
-- with respect to using the composite index for the initial keys
 - - CREATE INDEX ontrel_subjectid ON term_relationship(
subject_term_id
);

MySQL said:
#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 '--CREATE INDEX ontrel_subjectid ON
term_relationship(subject_term_id)' at line 1

So I tried with "compatibility with SQL323" (option in the
phpmyadmin), but got the same result.


-- 
Curso Biologia Molecular para programadores: http://tinyurl.com/2vv8w6
Bioinformatics news: http://www.bioinformatica.info
Tutorial libre de Python: http://tinyurl.com/2az5d5



More information about the Biopython mailing list