[ensembl-dev] MySQL MANUAL

[Emily Perry]

Hi Yossi

The schema for the MySQL databases can all be accessed from here:
http://www.ensembl.org/info/docs/api/index.html <http://www.ensembl.org/info/docs/api/index.html>

We provide BioMart, REST and the Perl APIs in order for people to query the database. If you want an easy way to query the database, that is the way to do it.
All the best

Emily

> On 19 Nov 2019, at 05:50, Joseph Steinberger <joseph.steinberger at weizmann.ac.il> wrote:
> 
> Hello Development team,
> 
> I made a local MySQL database of the entire Ensembl database. I would like to use regular MySQL commands to interface with the local MySQL data - as opposed to the Perl API.
> 
> Do you have printed material - pdfs - relating MySQL commands for the core, compara, regulation,variation, etc. databases?
> 
> I see the schema description which has specific SQL examples for compara but not for core. However, I am looking for something more pedagogically written, that illustrates how to do the more common BioMART and REST queries, using instead MySQL commands.
> 
> Sincerely,
> Yossi
> _______________________________________________
> Dev mailing list    Dev at ensembl.org <mailto:Dev at ensembl.org>
> Posting guidelines and subscribe/unsubscribe info: https://lists.ensembl.org/mailman/listinfo/dev_ensembl.org <https://lists.ensembl.org/mailman/listinfo/dev_ensembl.org>
> Ensembl Blog: http://www.ensembl.info/ <http://www.ensembl.info/>
--
Dr Emily Perry (Pritchard)
Ensembl Outreach Project Leader 
(she/her)

European Bioinformatics Institute (EMBL-EBI)
European Molecular Biology Laboratory 
Wellcome Genome Campus
Hinxton
Cambridge
CB10 1SD
UK 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20191119/34baecab/attachment.html>