How can I view all tables in a database with mysql?

2 years ago
Sophia Anderson
1 minute

You can use the following command to view all tables in a specific database:

  1. Connect to the MySQL database. You can connect to the MySQL database using the following command:
mysql -u [用户名] -p

One of them, [username], is your MySQL username. You will then be prompted to enter your password, and once entered correctly, you can log in.

  1. Choose the database you want to view. Use the following command to select the database you want to view:
USE [数据库名];

The database name specified is the name of the database you want to view.

  1. View all tables. Use the following command to view all tables in this database:
SHOW TABLES;

This will display the names of all tables in the database.

bannerAds