[problem]
You want to know how to do the following, through mysql command line interface:
- Connect to the mysql daemon
- Show the databases your user has access
- Show tables defined under that db
- Show schema for given table
[/problem]
[example]
mysql -u'username' -p'password' -h'mysql_host'
mysql_host is optional if the daemon is running on the same host.
Show databases
show databases;
Show tables
show tables;
Describe tables
use demo; describe demo;
For example:
mysql> show databases; +----------+ | Database | +----------+ | demo | | test | +----------+ 2 rows in set (0.00 sec) mysql> use demo; Database changed mysql> show tables; +----------------+ | Tables_in_demo | +----------------+ | demo_table | +----------------+ 1 row in set (0.00 sec) mysql> desc demo_table; +-------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+-------+ | id | mediumint(9) | | PRI | 0 | | | day | varchar(20) | | | | | | val | tinyint(4) | | | 0 | | +-------+--------------+------+-----+---------+-------+ 3 rows in set (0.10 sec)
[/example]
If you have found my website useful, please consider buying me a coffee below 😉