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, 3371🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Are the Differences between BINARY and VARBINARY in MySQL? Both BINARY and VARBINARY are both b...