HOW TO USE SQL | USE STATEMENT IN SQL - sql - sql tutorial - learn sql




  • The SQL USE statement is used to select any existing database in the SQL schema.
  • The USE keyword is used to select a database in MySQL and SQL Server.
Tags : sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorial

Syntax

  • The basic syntax of the USE statement is as shown below −
USE DatabaseName;
  • Always the database name should be unique within the RDBMS.
sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorial

Example

SQL> SHOW DATABASES;
Database
information_schema
AMROOD
wikitechy
mysql
orig
test
  • You can check the available databases as shown below −
  • 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.
SQL> USE AMROOD;

This tutorial provides more the basic needs and informations on sql tutorial , pl sql tutorial , mysql tutorial , sql server , sqlcode , sql queries , sql , sql formatter , sql join , w3schools sql , oracle tutorial , mysql , pl sql , learn sql , sql tutorial for beginners , sql server tutorial , sql query tutorial , oracle sql tutorial , t sql tutorial , ms sql tutorial , database tutorial , sql tutorial point , oracle pl sql tutorial , oracle database tutorial , oracle tutorial for beginners , ms sql server tutorial , sql tutorial pdf

Related Searches to USE STATEMENT IN SQL