Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications
DBMS BCA Unit-3 Introduction - SQL SQL - Data Types DDL - Commands SQL - CREATE DATABASE SQL - SELECT DATABASE SQL - DROP DATABASE SQL - CREATE TABLE SQL - DESCRIBE Statement SQL - DROP TABLE SQL - ALTER Statement SQL - INSERT INTO Statement SQL - DELETE Statement SQL - UPDATE Statement SQL - FOREIGN KEY SQL - INSERT INTO Example


SQL - SELECT DATABASE

When there are multiple databases in the SQL Schema, we would need to select a database before starting any operations to be performed on data.
The SQL USE statement is used to select any existing database from the SQL schema.
The basic syntax of USE statement is:

USE <Database Name>;

For example:
mysql> use testdb;
Database changed
mysql>