Monday, August 8, 2011

mysql console commands- first aid kit

Connect
> mysql -u root -p
(root password required)

Get a databases list
mysql> show databases;

Switch to a database
mysql> use [bd name];

See all the tables
mysql> show tables;

Show all data in a table
mysql> select * from [tabel name]


References
http://www.cyberciti.biz/faq/mysql-list-databases/
http://www.pantz.org/software/mysql/mysqlcommands.html

No comments: