title: What is more safe in MySQL, one field or many?
body: <p>I use PHP and MySQL. Lets say I have many IDs stored for later.</p>
  
  <p><strong>Example</strong></p>
  
  <p>After enter there is a new value. This might be an array.</p>
  
  <pre><code>prefix-1232
  pref-5453
  prefix54432
  pref-2233
  </code></pre>
  
  <p>As time goes I want to add more IDs to this "array" or what it might end up being. As I see it I have two choices.</p>
  
  <p><strong>1. Save the values as one big value in MySQL, maybe as a json converted array.</strong></p>
  
  <p>The benefit would be that it's faster to build. The downside which also is my question is if this method is insecure becuase I save all the IDs at the same time? If there is an error all values will be lost at once.</p>
  
  <p><strong>2. Save every value as new row in a new table (edited, not database)</strong></p>
  
  <p>The benefit would be that if I affect one row the rest of the values are not affected. The downside is that it takes more time to build and maybe other errors might accur instead.</p>
  
  <p>Which method is the safest, most correct and why?</p>