MYSQL - SELECT Database

How to SELECT a Database in MySql
1. Open your terminal. 

2. Connect to MySql.If not use below link to know how to connect.

How to Connect to MySql Database using MAC terminal

3. Once you logged into your mysql then type the below command 
to SELECT a database (OMS is database name).

mysql> use OMS; Database changed;

Which says Database 'OMS' is selected. 4. To check whether Database OMS selected or not type below command.

mysql> SELECT DATABASE(); +------------+ | DATABASE() | +------------+ | oms | +------------+ 1 row in set (0.00 sec)

Which says Database 'OMS' is selected.
***********Happy Learning*************

No comments:

Post a Comment

Featured Post

H1B Visa Stamping at US Consulate

  H1B Visa Stamping at US Consulate If you are outside of the US, you need to apply for US Visa at a US Consulate or a US Embassy and get H1...