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, 1335🔥, 0💬
Popular Posts:
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...