Suggest me...

Discussion in 'Databases' started by recruitermatenetworking, Nov 29, 2010.

0
  1. #1
    What is the query to get all tables from the selected database in MYSQL?
     
    recruitermatenetworking, Nov 29, 2010 IP
  2. imocoder

    imocoder Member

    Messages:
    45
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    43
    #2
    imocoder, Nov 30, 2010 IP
  3. plog

    plog Peon

    Messages:
    298
    Likes Received:
    11
    Best Answers:
    1
    Trophy Points:
    0
    #3
    SHOW TABLES FROM YourDatabaseNameHere;
     
    plog, Nov 30, 2010 IP
  4. iama_gamer

    iama_gamer Active Member

    Messages:
    404
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #4
    use DATABASENAME;
    show tables;
     
    iama_gamer, Dec 4, 2010 IP
  5. alexanime

    alexanime Peon

    Messages:
    39
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    and with the describe table you get the fields
     
    alexanime, Dec 5, 2010 IP
  6. murtaza231

    murtaza231 Member

    Messages:
    14
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    31
    #6
    use DATABASENAME;
    show tables;
     
    murtaza231, Dec 8, 2010 IP