title: mysql insert concatenate a constant value
body: <p>I want to insert a constant called TUC and concatenate it with the initials of FirstName and LastName id of table.</p>
  
  <p>id -   1 <br>
  fname -  James <br>
  lname -  Bond  <br></p>
  
  <p>id -   2 <br>
  fname -  Daniel <br>
  lname -  Edgar  <br> </p>
  
  <p>eg. TUCJB001, TUCDE002,....</p>