title: Theoretical: about php, mysql, comma separated values
body: <p>I have a database with employees. the columns are first name, last name, department, internal number etc..</p>
  
  <p>As for today it is a database only for one organization but in future i want to add to this database employees from other relative organizations.</p>
  
  <p>What is the right way to do it:</p>
  
  <ol>
  <li>To add another field to the first table ?</li>
  <li>To create another table with 3 fields: id, organization_name, employees ( where in this filed i would put comma separated values of id from first table) ?</li>
  </ol>
  
  <p>if the second answer will be chosen what will happened when an update query will be executed simultaneously from different accounts to the same organization. For example: i will be adding a user with id 55 to organization 'Police' and at the same time another administrator will be adding to the same organization a user with id 65..
  In this case is there a possibility of error or data-loss ???</p>
  
  <p>If someone had this kind of problem before, i really would like to read about it..
  Thank You..</p>