Basic commands of mysql

Last updated: April 25, 2023

After entering mysql database, we can show all available databases, also can enter any specific database, show all tables of this database etc are the basic operations of any database. That's not the part of sql but very important for working with any specific database.

Check all available databases:

show databases;
show databases command

Entering any specific database:

use databasename;

Here my database name is "learn_sql" for this course.

use learn_sql;
use database command

Show all tables in database:

show tables;
show tables command

Related post