title: Auto Populate Column In SQL
body: <p>I Have 2 Columns</p>
  <ol>
  <li>IDnumber</li>
  <li>User Name</li>
  </ol>
  <p>IDnumber is set to Auto_Increment So that it will be filled automatically starting from <code>10000</code> when a data is added
  I want to Auto populate the column Username by concatenating <code>IDnumber</code> and word <code>@BA</code></p>
  <p>So that When the IDnumber autoincrement is <code>10006</code> the User Name Will be <code>10006@BA</code></p>
  <p>I want to do this in my SQL Data Base</p>
  <ul>
  <li>The other data in the database is being filled using a PHP form</li>
  </ul>
  <p><a href="https://i.stack.imgur.com/pijwm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pijwm.png" alt="Diagram Example" /></a></p>