title: Converting multivalued column in table A to multiple rows in table B Mysql
body: <p>Given 2 tables, I want to convert the multivalued row in table 1</p>
  <p>Given 2 tables
  Table A</p>
  <pre><code>id  value
  ae  [1,2,4,5]
  ac  [1,6]
  </code></pre>
  <p>Table B</p>
  <pre><code>id  value
  ae   1
  ae   2
  ae   4
  ae   5
  ac   1
  ac   6
  </code></pre>
  <p>I know I have to insert a before insert trigger on table B, but I cannot figure out the logic.</p>