SQL Select Database – MySQL, PostgreSQL, SQL Server

Filed Under: SQL

When we work with different databases based on different requirements, we need to select the database before running any SQL command. The SQL command is then run post selection of database. Let us try to understand how to select a database in different Databases.

  1. MySQL
  2. PostgreSQL
  3. SQL Server

MySQL Select Database

In order to perform any operation on MySQL, it is important to select a database. Selection of a database from the mysql> prompt is done using SQL use command.

We will look into an example to understand this better.

[root@host]# mysql -u root -p 
Enter password:******
mysql> use TESTDB;
Database changed

In the above example, we have selected TESTDB as the database and the subsequent operations will be performed on the same database.

We can select the database (schema) in MySQL workbench by selecting it in the left-hand side panel.

MySQL Select Database

Database Select in MySQL workbench

In the above image, world schema is selected.

PostgreSQL Select Database

PostgreSQL allows selecting database in different ways. If we are using pgAdmin, we can just double click on the database and it will automatically select the database and will prompt for a password.

If we are using psql command-line client we can use the following command.

postgres=# \c testdb;
psql (9.2.4)
Type "help" for help.
You are now connected to database "testdb" as user "postgres".

In the above command, we are connecting to the testdb database.

For the UI part of PostgreSQL, we will be using pgAdmin, for selecting any database in pgAdmin, just double click on the database.

PostgreSQL Select Database

pgAdmin Select Database

SQL Server Select Database

In order to select a database in SQL server, please follow the below-mentioned steps.

  1. Connect to the database.
  2. On the left-hand side Object Explorer, expand the databases folder and double click on the database you want to select.
SQL Server Select Database

Select Database using SQLServer

Above mentioned are some ways to select the database. It is very important to select a database before performing any operation as otherwise, it might result in issues due to incorrect selection of the database.

Leave a Reply

Your email address will not be published. Required fields are marked *

Generic selectors
Exact matches only
Search in title
Search in content