0 votes
1 view
in SQL by (35.7k points)

Can anyone explain what is the default database in MySQL?

1 Answer

0 votes
by (86.2k points)

You can use the SHOW DATABASES statement lists all databases in the MySQL database server before you create a new database.

Here is the syntax to list all the databases in the server:

SHOW DATABASES;

You can observe the databases in the MySQL database server. The information_schema and MySQL are the default database in MySQL.

Selecting a database to work with

If you want to use a particular database you want to work with, you can do using the USE statement as below.

USE database_name;

If you want to learn MySQL from top professionals, then check out this SQL Certification program by Intellipaat.

Also, watch this video on MySQL:

Related questions

0 votes
1 answer
asked Jun 26 in SQL by Sudhir_1997 (35.7k points)
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...