Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Searching Database

forums › forums › SQLyog › Using SQLyog › Searching Database

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • July 14, 2009 at 5:21 pm #11584
      Hunterdxr
      Member

      Hello,

      I am trying to find information in my db but it is very time consuming having to find which table has the proper column then edit the SELECT statement for each table in a db with over 35 different tables.

      Is there a way to check ALL the tables from one query statement?

    • July 14, 2009 at 6:40 pm #29319
      peterlaursen
      Participant

      There is no such construction possible in SQL. In SQL you “SELECT some_colums FROM a_table” basically. But it would be possible of course to loop through all possibilities with some code. This is what you would typically write a client script or a Stored Procedure to do.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.