MySQL SELECT Database

MySQL | SELECT Database: Learn about the MySQL SELECT Database Statement, with its explanation, syntax, and query examples. How to select / use a database in MySQL?
Submitted by Apurva Mathur, on September 03, 2022

Select Database

In MySQL command-line client, if we want to work on a specific database then in that case we have to use the following statement.

To select a database, we can use SQL's USE command.

USE Command Syntax

Follow the given syntax to select (use) a database from the list of multiple databases.

USE DATABASE_NAME;

For Example:

SELECT Statement | Example 1

In the given picture we have many databases and at a time we can work on only a single database. So if I want to use the "student" database then I'll simply write,

USE student;
SELECT Statement | Example 2


Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.