show database , show tables

Question

what's the difference between show database and show tables?

Answer 1

A database is a collection of tables.

SHOW TABLES would show tables within a database.

SHOW DATABASES would show all databases on an SQL server.

Answer 2

If you're talking about MySQL, you can do according to the link below, use the 'use' command to connect to a specific database, like

use myDatabase;
show tables;

https://alvinalexander.com/blog/post/mysql/list-tables-in-mysql-database

Answer 3

so I have to specify what database I want to show its table ?

Answer 4

okay I get it ... thanks

Answer 5

N