Frequently Used DOS Command

Change Directory

1. c:\> e:

Show Directory Content

1. c:\>dir

Go to Specific Path

1. cd excellent\programming\tricks

Clear Path

1. cd / --Clear to end of the line
2. cd.. --back only one step

Run mySql in Command Prompt 

1. show databases;
2. show tables;
3. store tables;
4. create database abcdb;
5. use abcdb;
6. create table xyz (id int(20));
7. show table;

Create .bat file can directly run command prompt into mysql>.