title: How I can use the result of SELECT statement in ALTER TABLE in MySQL?
body: <p>I have a table with some properties. I would like use these properties to create some columns in another table (ALTER TABLE).</p>
  
  <p>The follow SELECT statement result in multiple results:</p>
  
  <pre><code>SELECT property FROM table1 GROUP BY property;
  </code></pre>
  
  <p>Result example:</p>
  
  <ul>
  <li>firstName</li>
  <li>lastName</li>
  <li>address</li>
  <li>phone</li>
  </ul>
  
  <p>For each result of select statement above, perform:</p>
  
  <pre><code>ALTER TABLE table2 ADD property boolean null;
  </code></pre>
  
  <p>How do?</p>