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 :

0 comments:

Post a Comment