title: Is it possible to have table in table (mysql)?
body: <p>Suppose I defined <code>music</code> as a table and gave it 3 columns: <code>album</code>, <code>artist</code>, and <code>track</code>:</p>
  
  <pre><code>CREATE TABLE music (
      id int auto_increment primary key,
      album varchar(45) not null,
      artist varchar(30) not null, 
      track int(8)
  ); 
  </code></pre>
  
  <p>Now I want another table <code>releasedy</code> which contains a column:</p>
  
  <pre><code>'Year' and the table music
  </code></pre>
  
  <p>I suppose for that I have to bind some row from table <code>music</code> with <code>year</code> from table <code>releasedy</code> in another table.  So I can know which year contains which musics.  If I'm not wrong I have to do that with foreign key.  How should I proceed?</p>