Collections:
List All Tables with "mysql" Command in MySQL
How To Show All Tables with "mysql" in MySQL?
✍: FYIcenter.com
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.
⇒ What Is "mysqlcheck" Command in MySQL
⇐ Use "mysql" to Run SQL Statements in MySQL
2018-02-28, 1873🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...