SQL tutorials for Business Analyst – SQL | SELECT Database, USE Statement

Hits: 14

(SQL tutorials for Business Analyst & Beginners)

In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | SELECT Database, USE Statement.

 

When you have multiple databases in your SQL Schema, then before starting your operation, you would need to select a database where all the operations would be performed.

The SQL USE statement is used to select any existing database in the SQL schema.

Syntax

The basic syntax of the USE statement is as shown below −

USE DatabaseName;

Always the database name should be unique within the RDBMS.

Example

You can check the available databases as shown below −

SQL> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| AMROOD             |
| mysql              |
| orig               |
| test               |
+--------------------+
6 rows in set (0.00 sec)

Now, if you want to work with the AMROOD database, then you can execute the following SQL command and start working with the AMROOD database.

 

 

Sign up to get end-to-end “Learn By Coding” example.


 

 

How to select model using Grid Search in Python