[Genome] using MySQL

Brooke Rhead rhead at soe.ucsc.edu
Sun Dec 23 23:58:29 PST 2007


Hello st kumer,

To select a database in MySQL, type: use (database name);

For instance, for the human March 2006 (hg18) assembly, type:

use hg18;

A list of UCSC databases is located here:
http://genome.ucsc.edu/FAQ/FAQreleases#release1

--
Brooke Rhead
UCSC Genome Bioinformatics Group



st kumer wrote:
> Hi,
>   I was trying to use the database via MySQL.
>   I have typed in the shell the command:
>   mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A
>   as I saw in the FAQ in the site.
>   The problem is that when I  type: show tables;
>   I get the message: No database selected
>   How do I select a database?
>   Thanks!
>
>        
> ---------------------------------
> Looking for last minute shopping deals?  Find them fast with Yahoo! Search.
> _______________________________________________
> Genome maillist  -  Genome at soe.ucsc.edu
> http://www.soe.ucsc.edu/mailman/listinfo/genome
>   


More information about the Genome mailing list