title: MySQL - How do I use CONCAT in ALTER TABLE?
body: <p>How do I concatenate in <code>ALTER TABLE</code>?</p>
  
  <p>I tried this, but it didn't work:</p>
  
  <pre><code>$sql1="ALTER TABLE t1 ADD iod = CONCAT('10.1234','/',id)"; 
  </code></pre>
  
  <p><code>id</code> is a different column in the same table.</p>