Basic instructions for using mysql database:
- Before connecting to the database please copy .my.cnf file to your home directory. The file contains the user information.
| Command description | Generic Command | Example/Comments/Links | |
|---|---|---|---|
| To enter mysql database | mysql | - | |
| To use a particular database | use dbname; | use hg19; | |
| To show all the tables | show tables; | show tables; | |
| To select everything from a table and limit to ten rows | select * from tablename limit no; | select * from allEnhancer limit 10; | |
| To crete a table and load data from an external file | - | example | |