title: MYSQL: Dynamic columns in mysql --> first, last name to full name:
body: <p>I was wondering if you have two columns for lets say</p>
  
  <pre><code>first name. 
  last name.
  </code></pre>
  
  <p>what you store in the database.</p>
  
  <p>Can you create a 'dynamic' column 'fullname' in the database that automatically creates the name out of the first and last name?</p>
  
  <pre><code>firstname   |lastname   |fullname (this goes automatically)
  -----------------------------------------
  foo         |bar        |foo bar 
  </code></pre>