title: How to store multiple values of user in mysql database?
body: <p>I have table like below.</p>
  
  <p><a href="https://i.stack.imgur.com/YU8wc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YU8wc.png" alt="enter image description here"></a></p>
  
  <p>I want to store user roles like <strong>admin,reader,writer</strong></p>
  
  <p>How can I store the values in my table.</p>
  
  <p>I searched in google and many results such as 2 types.</p>
  
  <ol>
  <li>Storing values to a single <strong>column name</strong> as <strong>user_roles</strong> and store values with pipe (|) separated (same as above).</li>
  <li>Storing values on another table like <strong>user_roles</strong> and store with foreign key of users.</li>
  </ol>
  
  <p>Which of the above two method is better for development ?</p>
  
  <p>Tell me the advantage and dis-advantage of both please...</p>
  
  <p>Thanks &amp; Regards</p>