title: MySQL - Set default value for field as a string concatenation function
body: <p>I have a table that looks a bit like this actors(forename, surname, stage_name);</p>
  
  <p>I want to update stage_name to have a default value of</p>
  
  <pre><code>forename." ".surname
  </code></pre>
  
  <p>So that</p>
  
  <pre><code>insert into actors(forename, surname) values ('Stack', 'Overflow');
  </code></pre>
  
  <p>would produce the record</p>
  
  <pre><code>'Stack'     'Overflow'    'Stack Overflow'
  </code></pre>
  
  <p>Is this possible?</p>
  
  <p>Thanks :)</p>