How To Show All Tables With "mysql"

  • 21 Mar, 2012

    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 in>mysql -u root testWelcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 14 to server version: 5.0.24mysql> 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.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 All rights reserved.