title: MySQL: Getting all columns in a table in a certain database
body: <p>I have several databases that have tables with the same name. </p>
  
  <p>I mean, I got the following databases
  <code>mydb1</code>, <code>mydb2</code>, etc</p>
  
  <p>and each mydb has a table called <code>myTable</code>. But these tables have diffenet columns:</p>
  
  <pre><code>myTable in mydb1
  id, name, age
  
  myTable in mydb2
  id, name, street, size
  </code></pre>
  
  <p>Now, if I had only one Database <code>mydb1</code> then I also had only one Table <code>MyTable</code>. If I wanted to know all the columns in that table I would make the following sql request</p>
  
  <pre><code>use information_schema;
  select column_name from columns where table_name = 'myTable';
  </code></pre>
  
  <p>In that case this works fine, I get the columns I'm looking for. </p>
  
  <p>But, in my case I have several tables called MyTable in different Databases. And the same sql request yields:</p>
  
  <pre><code>id, name, age, id, name, street, size
  </code></pre>
  
  <p>But I just want to have the columns of <code>mydb1.myTable</code>.</p>
  
  <p>How can I get only the columnnames from just one <code>myTable</code>?</p>
  
  <p>Hint: I just want to have the column names not the type, nulls oder keys. Therefore the request <code>show columns from mydb1.myTable</code> is not what I'm looking for.</p>