title: insert data from multiple rows to one row mysql
body: <p>Ok here's the thing. I need to insert multiple rows in one column from table A to one row in table B using MySql</p>
  
  <p>Here's an example of what im trying to achieve:</p>
  
  <pre><code>Table A
  id | data
  1  | name
  2  | date
  3  | more
  </code></pre>
  
  <p>From table A, i need to select all the rows in the data column and insert that data in one row of 'data' column of table B 
  like this:</p>
  
  <pre><code>Table B 
  id | data
  1  | name, date, more
  </code></pre>
  
  <p>Here is my current code, however it isn't working and shows me an error <code>subquery returns more than one row</code></p>
  
  <pre><code>INSERT INTO B (data) values (SELECT data from A)
  </code></pre>
  
  <p>Is there any way i can do this? Please excuse as i am a newbie :P</p>
  
  <p>Thanks in advance!</p>