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, 1306🔥, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...