List All Tables with "mysql" Command in MySQL

Q

How To Show All Tables with "mysql" in MySQL?

✍: FYIcenter.com

A

If you want to see all the tables in a database, you run the non-SQL command "SHOW TABLES" at the "mysql" prompt. See the following tutorial exercise for example:

>cd \mysql\bin
>mysql -u root test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 5.0.24

mysql> SHOW TABLES;
+----------------+
| Tables_in_test |
+----------------+
| links          |
+----------------+
1 row in set (0.01 sec)

The output shows you that there is only one table in the "test" database.

 

⇒Administrator Tools for Managing MySQL Server

⇒⇒MySQL Database Tutorials

2016-10-16, 172👍, 0💬

General MySQL Oracle SQL Server