title: How to store arrays in MySQL?
body: <p>I have two tables in MySQL. Table Person has the following columns:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>name</th>
  <th>fruits</th>
  </tr>
  </thead>
  </table>
  </div>
  <p>The <code>fruits</code> column may hold null or an array of strings like ('apple', 'orange', 'banana'), or ('strawberry'), etc. The second table is Table Fruit and has the following three columns:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>fruit_name</th>
  <th>color</th>
  <th>price</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>apple</td>
  <td>red</td>
  <td>2</td>
  </tr>
  <tr>
  <td>orange</td>
  <td>orange</td>
  <td>3</td>
  </tr>
  <tr>
  <td>-----------</td>
  <td>--------</td>
  <td>------</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>So how should I design the <code>fruits</code> column in the first table so that it can hold array of strings that take values from the <code>fruit_name</code> column in the second table? Since there is no array data type in MySQL, how should I do it?</p>