Mysql Basic
- Start mysql from start menu
- It will ask you password just enter whatever you specified while installing mysql.
- you get mysql> prompt
- To view available databases fire up : show databases;
- To select database fire up : use databasename;
- 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 :
My SQL Frequent commands :
0 comments:
Post a Comment