MySQL USE Database: Switch Between Databases in MySQL

Tutorial

Sign Up

log In

MYSQL

MySQL Tutorial

MySQL Introduction

MySQL AND, OR, NOT

MySQL INSERT INTO

MySQL MIN and MAX

MySQL COUNT, AVG, SUM

MySQL LEFT JOIN

MySQL RIGHT JOIN

MySQL CROSS JOIN

MySQL Self Join

MySQL INSERT SELECT

MySQL NULL Values

MySQL Operators

MySQL Database

MySQL Create DB

MySQL Create Table

MySQL Drop Table

MySQL Alter Table

MySQL Constraints

MySQL PRIMARY KEY

MySQL FOREIGN KEY

MySQL CREATE INDEX

MySQL AUTO_INCREMENT

MySQL USE DB

❮ Previous

Next ❯

MySQL USE Database Statement

The USE statement in MySQL is used to select and switch to a specific database, making it the active database for subsequent queries.

Syntax:

USE database_name;

database_name is the name of the database you want to use.

Example: Switching to a Database

Switch to the school_db database

USE school_db;

After executing this command, all queries will run within school_db unless another database is selected.

Checking the Selected Database

To verify the active database:

SELECT DATABASE();

Listing Available Databases

To see all databases in MySQL:

SHOW DATABASES;

All Database statements:

✔ The USE statement sets the active database.

✔ All queries after USE database_name; apply to the selected database.

✔ Use SHOW DATABASES; to list available databases.

✔ Use SELECT DATABASE(); to check the current database.

❮ Previous

Next ❯

Whereisstuff is simple learing platform for beginer to advance level to improve there skills in technologies.we will provide all material free of cost.you can write a code in runkit workspace and we provide some extrac features also, you agree to have read and accepted our terms of use, cookie and privacy policy.

© Copyright 2024 www.whereisstuff.com. All rights reserved. Developed by whereisstuff Tech.