[Genome] using MySQL

[Hiram Clawson]

Good Morning:

If you place the database name on your mysql command line,
that will be the database in use, for example to use hg18:

mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A hg18

Or, after you have a MySQL prompt, issue a 'use' statement:
mysql> use hg18;
Database changed
mysql>

Please note the MySQL reference manual:
	http://dev.mysql.com/doc/refman/4.1/en/mysql.html

--Hiram

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!