1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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