title: How do I export data from one table to another (MYSQL)
body: <p>It is not as easy as the title itself. I have a table <code>users</code> which has a field <code>assignedlessons</code>. Data stored in this field is like <code>69|308|50|91</code>. As you may have already know, it keep several lessons of a user has at the same time. What I am going to do is to export data from this field along with <code>user_id</code> and import to another newly created table <code>user_assigned_elearning_lessons</code>. The structure of this table is: <code>id</code>, <code>user_id</code>, <code>elearning_lesson_id</code>, <code>created_at</code>. After the importing, the structure in the new table should be like this:</p>
  
  <pre><code>id        user_id       elearning_lesson_id        created_at
  1         1             69                         2011-01-12
  2         1             308                        2011-04-11
  3         2             50                         2011-05-18
  4         3             91                         2011-05-21
  5         3             50                         2011-07-18
  6         3             308                        2011-07-18
  </code></pre>
  
  <p>How do I do that?</p>