0
show database , show tables
what's the difference between show database and show tables?
5 Réponses
+ 6
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.
+ 3
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
0
so I have to specify what database I want to show its table ?
0
okay I get it ... thanks
0
N
Vous avez souvent des questions comme celle-ci ?
Apprenez de manière plus efficace, gratuitement :
