Mysql Basic

1. Start mysql from start menu
2. It will ask you password just enter whatever you specified while installing mysql.
3. you get mysql> prompt
4. To view available databases fire up : show databases;
5. To select database fire up : use databasename;
6. To show created tables in mysql fire up : show tables;

Very small introduction for connecting to mysql database! rest you can execute your own queries there on prompt...


My SQL Frequent commands :

• http://www.pantz.org/software/mysql/mysqlcommands.html
• http://www.tutorialspoint.com/mysql/mysql-select-database.htm