Thursday, September 3, 2015

MySQL Using Terminal

1) Log into the MySQL Server

Command : mysql -u root -p
                

   Provide your root password & press enter.



2) Check available databases.

Command : show databases ;  (At the end, you must end the command using  " ; " )


3)Select one schema.

Command: use <schema name> ;
eg:- use ict_centre_schema;

 4) Check Available Tables in the DB

Command: show tables;


5) Describe a table

Command: desc <Table Name> ;
eg:- desc admin;