MySQL Tutorial

MySQL – Create Database

MySQL – Select Database

MySQL – Drop Database

MySQL – Create Table

MySQL – Drop Table

MySQL Truncate Table

MySQL Insert Query

MySQL Delete Query

MySQL Select Query

MySQL Update Query

MySQL Where Clause

MySQL Distinct Clause

MySQL Group By Clause With Example

How to Find Duplicate Email Records in User Table

MySQL – Select Database

By: Prem Tiwari | Last Updated: September 11, 2017 | In: MySQL Tutorial

After database created, select that database for doing database operations like create table, alter table, and etc..

For selecting the database you can use the below SQL command.

1

2

3

USE database_name;

Here is the example with created database “mysql_tutorial”, select the created database by using the below query.

1

2

3

USE mysql_tutorial;

MySQL - Select Database