MySQL Programming Question:

How To Show All Tables with "mysql"?

Tweet Share WhatsApp

Answer:

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 mysqlin
>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;
<pre>+----------------+
| Tables_in_test |
+----------------+
| links |
+----------------+</pre>
1 row in set (0.01 sec)

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

Download MySQL Programming PDF Read All 110 MySQL Programming Questions
Previous QuestionNext Question
How To Use "mysql" to Run SQL Statements?What Is "mysqlcheck"?