Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to show table list in a database in MySQL?

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 205
    Comment on it

    Sometimes we need to find table list present in a database so that we can identify which table we have to create and which one not.

    To work in a particular database we need to use the below statement first:

    use database_name;
    

    Example:

    use demo;
    

    the above statement brings you inside the "demo" database.

    then use the below statement:

    show tables;
    

    the above statement will list all the tables in the "demo" database.

    Hope this will help you :)

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: