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, 1515🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
Where to find reference information and tutorials on MySQL database functions? I want to know how to...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...