Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    5

    Unanswered: Search for the table in a Database

    If I'm login to MySQL and want to find certain table, but I have no idea where the table is located (in what database).

    How can I search for a table in mysql ?

    Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    you wanna search for a table programatically or manually?
    qha_vn

  3. #3
    Join Date
    Jul 2003
    Location
    SouthWest USA
    Posts
    7

    Re: Search for the table in a Database

    Originally posted by mikeshn
    If I'm login to MySQL and want to find certain table, but I have no idea where the table is located (in what database).

    How can I search for a table in mysql ?

    Thanks
    Brute force way -- show databases;
    Then for each database returned --
    use "one of the returned database";
    show tables;

  4. #4
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    You can try
    Code:
    show tables like 'your table name'
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •