title: Concatenate Columns on Import (MySQL/phpmyadmin)
body: <p>I have a table with a basic structure...
  column1, column2, column3.</p>
  
  <p>When I upload to this table on phpmyadmin (or any other environment for that matter), I would like to be able to add a fourth column which is a concatenation of the three columns being uploaded.</p>
  
  <p>Is there any way of creating a column which is the equivalent of <code>CONCAT(column1, column2, column3) as column4</code> so that each time I import to this table, column4 will be populated automatically?</p>
  
  <p>I'm trying to avoid having to do this work before import or after, which I presume would require creating an additional table.</p>
  
  <p>Any help would be appreciated.</p>
  
  <p>Cheers, Ste</p>