how to see database tables in mysql code example

Example 1: how to see database in mysql command line

SHOW DATABASES;

Example 2: mysql show all tables

show tables;

Example 3: mysql command show tables

SHOW TABLES;

Example 4: how to see database in mysql command line

mysql -u user -p